Magnus Hagander's PostgreSQL blog

Entries from January 2012

Topics from January, 2012

203 - Finding gaps in partitioned sequences

Friday, January 27. 2012. Posted by Magnus Hagander in PostgreSQL

Calendar

Upcoming conferences

Planned Conferences

PGCon

Tentative conferences

Postgres Open

Past conferences

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

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

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 t he column name, then minus the operator, then lag the [...]

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

Magnus Hagander about www.postgresql.org - brand new, yet old and familiar

Thu, 22.12.2011 14:08

I didn't see that when I check ed, but there was a bug that c aused it to cache the internal errors for several hour [...]

Hans about www.postgresql.org - brand new, yet old and familiar

Thu, 22.12.2011 11:14

The page with the mail archive is no longer working: htt p://www.postgresql.org/communi ty/ Shows me "An inte [...]

Tweets

magnushagander: @OttawaHotel4U funny. Given this has easily been my worst hotel stay for years, that won't happen. Total service fail is not good marketing.

magnushagander: @OttawaHotel4U it has not been even remotely fixed. Which I've reported many times.

magnushagander: OH: "We found somebody already downloaded [the code] and wrote a paper about it" #pgcon

magnushagander: @pvh yeah. All those brains exploding might make it messy...