Hi,
I am able to apply your patch successfully but I am still getting
compilation error
./configure --enable-depend --enable-cassert
make
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing
-fwrapv -I. -I../../../src/include -D_
On Thu, 1 Jul 2004 22:55:56 -0400, Mike Rylander <[EMAIL PROTECTED]>
wrote:
>I was thinking of purely tablespace-based random_page_cost, as that variable
>is tied to the access time of a particular filesystem.
Strictly speaking we'd also need tablespace-based sequential_page_cost.
Servus
Manfre
On Thursday 01 July 2004 08:54 pm, Gavin Sherry wrote:
> On Thu, 1 Jul 2004, Mike Rylander wrote:
> > On Thursday 01 July 2004 06:43 pm, Gavin Sherry wrote:
> > > Hi Mike,
> > >
> > > In this release, unfortunately not.
> >
> > That't too bad, but it's not that urgent I suppose.
> >
> > > I had som
On Thursday 01 July 2004 09:26 pm, Scott Marlowe wrote:
> On Thu, 2004-07-01 at 18:54, Gavin Sherry wrote:
> > On Thu, 1 Jul 2004, Mike Rylander wrote:
> > > On Thursday 01 July 2004 06:43 pm, Gavin Sherry wrote:
> > > > Hi Mike,
> > > >
> > > > In this release, unfortunately not.
> > >
> > > That'
On Thursday 01 July 2004 06:43 pm, Gavin Sherry wrote:
> Hi Mike,
>
> In this release, unfortunately not.
That't too bad, but it's not that urgent I suppose.
>
> I had some idea early on of putting rand_page_cost in pg_tablespace and
> having the planner have access to it for costing. I didn't ac
I would like to see some tool that reported an semi-accurate value for
random page cost before adding the value per tablespace.
---
Scott Marlowe wrote:
> On Thu, 2004-07-01 at 18:54, Gavin Sherry wrote:
> > On Thu, 1 Jul 20
On Thu, 2004-07-01 at 18:54, Gavin Sherry wrote:
> On Thu, 1 Jul 2004, Mike Rylander wrote:
>
> > On Thursday 01 July 2004 06:43 pm, Gavin Sherry wrote:
> > > Hi Mike,
> > >
> > > In this release, unfortunately not.
> >
> > That't too bad, but it's not that urgent I suppose.
> >
> > >
> > > I had
On Thu, 1 Jul 2004, Mike Rylander wrote:
> On Thursday 01 July 2004 06:43 pm, Gavin Sherry wrote:
> > Hi Mike,
> >
> > In this release, unfortunately not.
>
> That't too bad, but it's not that urgent I suppose.
>
> >
> > I had some idea early on of putting rand_page_cost in pg_tablespace and
> > h
Hi Mike,
In this release, unfortunately not.
I had some idea early on of putting rand_page_cost in pg_tablespace and
having the planner have access to it for costing. I didn't actually get
around to it but. :-(
Gavin
On Mon, 28 Jun 2004, Mike Rylander wrote:
> Now that PG will have tablespaces
Now that PG will have tablespaces I can stick my really high I/O data on a
fiberchannel array, and save some money by putting the rest of it (also the
majority of it) on less expensive SCSI RAID sets. Will I also be able to
tune individual tablespaces with the likes of random_page_cost? Sorry if
Thanks - that's what I ended up doing. Hooray for CLUSTER indexes and
constraints in phpPgAdmin CVS now!
Chris
Tom Lane wrote:
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
If someone could help me with this, it would be cool. How do I query
the catalogs to find the underlying index f
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> If someone could help me with this, it would be cool. How do I query
> the catalogs to find the underlying index for a constraint? (Assuming
> the constraint is primary or unique)
A first approximation is that the constraint and the index h
On Fri, 3 Oct 2003, Christopher Kings-Lynne wrote:
> Hi guys,
>
> If someone could help me with this, it would be cool. How do I query
> the catalogs to find the underlying index for a constraint? (Assuming
> the constraint is primary or unique)
>
For a primary key you can do:
SELECT cls.rel
Hi guys,
If someone could help me with this, it would be cool. How do I query
the catalogs to find the underlying index for a constraint? (Assuming
the constraint is primary or unique)
Chris
---(end of broadcast)---
TIP 1: subscribe and unsub
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> Were the pgattribute.attstorage and pg_type.typstorage fields available in
> 7.1?
Yes, but typstorage did not appear in 7.0, which you're also supposed to
think about if you're hacking pg_dump. (AFAICT attstorage was always
'p' in 7.0.)
> A
Hi Guys,
Were the pgattribute.attstorage and pg_type.typstorage fields available in
7.1?
Also, if they existed in 7.2, but the ALTER TABLE/SET STORAGE command didn't
exist, should I still dump it if they are dumping a 7.2 database?
Chris
---(end of broadcast)--
Hi:
A really simple question: I wanna set up some WAL related config
parameter. I am wondering is it the same to add those parameter on
postgresql.conf as to add them on /etc/rc.d/init.d/postgres.init??
---(end of broadcast)---
TIP 5: Have you chec
Peter T Mount <[EMAIL PROTECTED]> writes:
> Just a quick question, but how much of SQL92 Entry Level does 7.1
> support, and what parts haven't we got (yet)?
I don't think anyone's made a careful list --- making one is on my
personal to-do list for the near future, but not yet at the top.
Schema
Just a quick question, but how much of SQL92 Entry Level does 7.1 support, and
what parts haven't we got (yet)?
I need to know for a couple of internal bits in the JDBC driver...
Peter
--
Peter Mount [EMAIL PROTECTED]
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF libr
19 matches
Mail list logo