Magnus Hagander's PostgreSQL blog

Archives

2013
May 0 entries (view full) (view topics)
April 1 entries (view full) (view topics)
March 1 entries (view full) (view topics)
February 1 entries (view full) (view topics)
January 0 entries (view full) (view topics)

2012
December 2 entries (view full) (view topics)
November 0 entries (view full) (view topics)
October 0 entries (view full) (view topics)
September 1 entries (view full) (view topics)
August 0 entries (view full) (view topics)
July 1 entries (view full) (view topics)
June 0 entries (view full) (view topics)
May 2 entries (view full) (view topics)
April 0 entries (view full) (view topics)
March 1 entries (view full) (view topics)
February 0 entries (view full) (view topics)
January 1 entries (view full) (view topics)

2011
December 1 entries (view full) (view topics)
November 2 entries (view full) (view topics)
October 1 entries (view full) (view topics)
September 1 entries (view full) (view topics)
August 2 entries (view full) (view topics)
July 1 entries (view full) (view topics)
June 0 entries (view full) (view topics)
May 3 entries (view full) (view topics)
April 2 entries (view full) (view topics)
March 1 entries (view full) (view topics)
February 1 entries (view full) (view topics)
January 3 entries (view full) (view topics)

2010
December 3 entries (view full) (view topics)
November 4 entries (view full) (view topics)
October 1 entries (view full) (view topics)
September 3 entries (view full) (view topics)
August 0 entries (view full) (view topics)
July 3 entries (view full) (view topics)
June 1 entries (view full) (view topics)
May 1 entries (view full) (view topics)
April 1 entries (view full) (view topics)
March 2 entries (view full) (view topics)
February 4 entries (view full) (view topics)
January 2 entries (view full) (view topics)

2009
December 2 entries (view full) (view topics)
November 4 entries (view full) (view topics)
October 1 entries (view full) (view topics)
September 2 entries (view full) (view topics)
August 1 entries (view full) (view topics)
July 1 entries (view full) (view topics)
June 2 entries (view full) (view topics)
May 5 entries (view full) (view topics)
April 1 entries (view full) (view topics)
March 2 entries (view full) (view topics)
February 3 entries (view full) (view topics)
January 3 entries (view full) (view topics)

2008
December 5 entries (view full) (view topics)
November 4 entries (view full) (view topics)
October 4 entries (view full) (view topics)
September 2 entries (view full) (view topics)
August 0 entries (view full) (view topics)
July 0 entries (view full) (view topics)
June 0 entries (view full) (view topics)
May 4 entries (view full) (view topics)
April 2 entries (view full) (view topics)
March 1 entries (view full) (view topics)
February 4 entries (view full) (view topics)
January 3 entries (view full) (view topics)

2007
December 0 entries (view full) (view topics)
November 1 entries (view full) (view topics)
October 1 entries (view full) (view topics)
September 1 entries (view full) (view topics)
August 0 entries (view full) (view topics)
July 5 entries (view full) (view topics)
June 0 entries (view full) (view topics)
May 2 entries (view full) (view topics)
April 2 entries (view full) (view topics)
March 5 entries (view full) (view topics)
February 9 entries (view full) (view topics)
January 8 entries (view full) (view topics)

2006
December 5 entries (view full) (view topics)
November 5 entries (view full) (view topics)
October 1 entries (view full) (view topics)
September 3 entries (view full) (view topics)
August 4 entries (view full) (view topics)
July 4 entries (view full) (view topics)
June 2 entries (view full) (view topics)
May 2 entries (view full) (view topics)
April 1 entries (view full) (view topics)
March 2 entries (view full) (view topics)
February 4 entries (view full) (view topics)
January 2 entries (view full) (view topics)

2005
December 3 entries (view full) (view topics)
November 2 entries (view full) (view topics)
October 4 entries (view full) (view topics)
September 5 entries (view full) (view topics)
August 4 entries (view full) (view topics)
July 1 entries (view full) (view topics)
June 6 entries (view full) (view topics)
May 7 entries (view full) (view topics)
April 2 entries (view full) (view topics)

Calendar

Back May '13
Mon Tue Wed Thu Fri Sat Sun
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    

Archives

Upcoming conferences

Planned Conferences

Tentative conferences

  • OpenSource Days

Past conferences

  • PGConf.EU 2012
  • Postgres Open 2012
  • PGCon 2012
  • GoOpen
  • Software Passion Summit
  • OpenSource Days
  • Prague PostgreSQL Dev Day
  • FOSDEM 2012
  • PGDay.IT 2011
  • FSCONS 2011
  • Postgres Open 2011
  • PGConf.EU 2011
  • Char(11) 2011
  • EuroPython 2011
  • PGCon 2011
  • NLUUG Spring
  • PG-East 2011
  • OpenSource Days 2011
  • P2D2 2011
  • FOSDEM 2011
  • PGDay.EU 2010
  • PG-West 2010
  • PG-East 2010
  • PGCon 2010
  • OpenSource Days 2010
  • FOSS-Stockholm #1
  • FOSDEM 2010
  • JPUG 2009
  • FSCONS
  • PGDay.EU 2009
  • PGcon.BR 2009
  • JDCon West 2009
  • Highload++ 2009
  • PGCon 2009
  • Prague PG Day 2009
  • FOSDEM 2009
  • FSCONS 2008
  • PGDay.EU 2008
  • Open Source Days 2008
  • PG-West 2008
  • PGCon 2008
  • PG-East 2008
  • FOSDEM 2008

Tags

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Latest comments

Matt Spencer about PostgreSQL vs 64-bit windows
Wed, 06.06.2012 05:23
I agree totally, the 64-bit ve rsion definitely solves the pr oblem if you need more memory. We need to gradually sh [...]
Jim Smithson about PostgreSQL vs 64-bit windows
Tue, 05.06.2012 07:04
Users who are challenged by th e memory taxing qualities of t he 64 bit should go back to us ing 32 bit. It offers sm [...]
Magnus Hagander about PostgreSQL vs 64-bit windows
Thu, 19.04.2012 08:22
You are missing the point - wh ich is exactly that the filesy stem level cache does not ha ve a lower cache hit rat [...]
Marcov about PostgreSQL vs 64-bit windows
Mon, 26.03.2012 19:57
Any VM base caching is limited to the maximal mappable addre ss space(which is about 4G in windows 64-bit, 3GB in 3 [...]
Magnus Hagander about Finding gaps in partitioned sequences
Mon, 06.02.2012 10:18
Hah, thanks for pointing that out. That's what I get for try ing to clean up the formatting when posting it...
mark about Finding gaps in partitioned sequences
Tue, 31.01.2012 19:01
thanks, sorry I should have no ticed that was the seq MINUS t he lag function. p.s. you example may have a typo [...]
Magnus Hagander about Finding gaps in partitioned sequences
Mon, 30.01.2012 17:25
No, there are no user defined functions in this. seq is the column name, then minus the o perator, then lag the bu [...]
mark about Finding gaps in partitioned sequences
Mon, 30.01.2012 17:23
what is seq-lag ? i assume thi s is a user defined func.
Magnus Hagander about www.postgresql.org - brand new, yet old and familiar
Thu, 22.12.2011 17:41
Yeah, unfortunately we are sti ll waiting on David to migrate the content over there.
Dave about www.postgresql.org - brand new, yet old and familiar
Thu, 22.12.2011 16:55
The weekly news page (http://w ww.postgresql.org/community/we eklynews/) seems to be broken. I see only a couple of [...]
tweetbackcheck