Magnus Hagander's PostgreSQL blog

Entries from March 2009

Topics from March, 2009

140 - Updates to the postgresql.org git service

Friday, March 27. 2009. Posted by Magnus Hagander in PostgreSQL git

139 - PostgreSQL security updates are out

Tuesday, March 17. 2009. Posted by Magnus Hagander in PostgreSQL

Calendar

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

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 [...]