Re: [PATCHES] COPY Fillfactor patch

2005-04-20 Thread Simon Riggs
On Wed, 2005-04-20 at 09:42 -0400, Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > On Wed, 2005-04-20 at 09:03 -0400, Bruce Momjian wrote: > >> My guess is that the FILLFACTOR will actually be a GUC variable rather > >> than a clause to CREATE INDEX or REINDEX or CLUSTER. > > > I hop

Re: FW: [PATCHES] Implementation of SQLSTATE and SQLERRM variables

2005-04-20 Thread Alvaro Herrera
On Wed, Apr 20, 2005 at 11:51:33AM +0530, Dinesh Pandey wrote: > I am trying to apply "sqlstate.diff" patch for SQLERRM and SQLSTATE for > plpgsql. > > 1. I have copied "sqlstate.diff" in "postgresql-8.0.1/src/pl/plpgsql/src" > directory. > 2. Executing command: > patch -p4 < sqlstate.diff

Re: [PATCHES] COPY Fillfactor patch

2005-04-20 Thread Bruce Momjian
Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > On Wed, 2005-04-20 at 09:03 -0400, Bruce Momjian wrote: > >> My guess is that the FILLFACTOR will actually be a GUC variable rather > >> than a clause to CREATE INDEX or REINDEX or CLUSTER. > > > I hope not, but it would be easier to se

Re: [PATCHES] COPY Fillfactor patch

2005-04-20 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > On Wed, 2005-04-20 at 09:03 -0400, Bruce Momjian wrote: >> My guess is that the FILLFACTOR will actually be a GUC variable rather >> than a clause to CREATE INDEX or REINDEX or CLUSTER. > I hope not, but it would be easier to set like that and a lot easier

Re: [PATCHES] COPY Fillfactor patch

2005-04-20 Thread Simon Riggs
On Wed, 2005-04-20 at 09:03 -0400, Bruce Momjian wrote: > My guess is that the FILLFACTOR will actually be a GUC variable rather > than a clause to CREATE INDEX or REINDEX or CLUSTER. I hope not, but it would be easier to set like that and a lot easier to code up that way. Trouble is, if you need

Re: [PATCHES] COPY Fillfactor patch

2005-04-20 Thread Simon Riggs
On Wed, 2005-04-20 at 02:08 +0300, Hannu Krosing wrote: > > Anyway, when I get time, I'll finish off the patch. Unless other readers > > would like to follow on. > > I hope you will you will get that time before 8.1 ships :) It's very unlikely, sorry. I'm working towards improving Business Intel

Re: [PATCHES] COPY Fillfactor patch

2005-04-20 Thread Bruce Momjian
My guess is that the FILLFACTOR will actually be a GUC variable rather than a clause to CREATE INDEX or REINDEX or CLUSTER. --- Hannu Krosing wrote: > On T, 2005-04-12 at 18:38 +0100, Simon Riggs wrote: > > On Tue, 2005-04-1

Re: [PATCHES] COPY Fillfactor patch

2005-04-20 Thread Hannu Krosing
On T, 2005-04-12 at 18:38 +0100, Simon Riggs wrote: > On Tue, 2005-04-12 at 09:56 -0400, Tom Lane wrote: (Neil, I added you to CC: to show you at least two more places where sparse heaps can be generally useful and not tweaks for single benchmark) > > Simon Riggs <[EMAIL PROTECTED]> writes: > > >

Re: [PATCHES] WIP XLog Switch

2005-04-20 Thread Simon Riggs
On Tue, 2005-04-19 at 19:44 +0100, Simon Riggs wrote: > Main issue is the need to poke the xlog record pointer with a new value > after the log switch. I'm a little uncertain about that approach and I'm > very likely getting it wrong now. Better ideas welcome. Happier with that approach now. Worki