Shridhar Daithankar wrote:
Something like select reltuples from pg_class where relname='foo'?
Shridhar
[chuckles] - I had envisaged something more accurate that the last
ANALYZE, "estimate_count" would effectively *do* acquire_sample_rows()
then and there for you...
regards
Mark
---
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> I must confess that it strikes me as a really really horrid and ugly
> hack - very likely to be error-prone and non-portable and undebuggable,
> and for almost no saving worth having. But maybe that's just me.
No, that was exactly my reaction too. I'
Andrew Dunstan wrote:
>
>
> Bruce Momjian wrote:
>
> >Gaetano Mendola wrote:
> >
> >
> >>I don't think the article is available online, alas, but you can find some
> >>related source code demonstrating the technique at:
> >>
> >>http://www.semantics.org/tyr/tyr0_5/list.h
> >>
> >>
> >
Kurt Roeckx wrote:
On Sat, Dec 06, 2003 at 01:30:02PM -0600, Seum-Lim Gan wrote:
Hi,
The ident server we currently use is pidentd 3.0.16
from :
http://www.lysator.liu.se/ or
ftp://ftp.lysator.liu.se/pub/ident/servers
The ChangeLog of it says: Solaris 8 (including IPv6) support
added.
Bu
Bruce Momjian wrote:
Gaetano Mendola wrote:
I don't think the article is available online, alas, but you can find some
related source code demonstrating the technique at:
http://www.semantics.org/tyr/tyr0_5/list.h
That certainly is an amazing idea. You know the pointer you are coming
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> That's no fix --- it will break the code on compilers without long long.
> Here are the emails describing the problem. Seems they should see how
> we do time differences in the backend as an example.
Now that I look at it, the code i
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]
> Sent: Saturday, December 06, 2003 5:02 PM
> To: Gaetano Mendola
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Double linked list with one pointer
>
>
> Gaetano Mendola wrote:
> > If I'm not wrong Neil Conway is wor
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I am still reading email from yesterday, but this is a new patch in the
> > past 2 days. The problem is that time differences were overflowing int
> > values if the vacuum took a long time, or something like that. The fix
> > is to c
Gaetano Mendola wrote:
> If I'm not wrong Neil Conway is working on
> reimplement a double linked list.
> Looking around I found this post of
> "Herb Sutter" on comp.lang.c++:
>
>
> In particular, a motivation behind two-way
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I am still reading email from yesterday, but this is a new patch in the
> past 2 days. The problem is that time differences were overflowing int
> values if the vacuum took a long time, or something like that. The fix
> is to cast one to long long.
Tha
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > So we have SSL, information schema (bit), and autovacuum. The last one
> > is an easy fix, not sure on the others.
>
> I thought you already applied those autovacuum patches? Is there
> something else pending for it?
I am still rea
Bruce Momjian <[EMAIL PROTECTED]> writes:
> So we have SSL, information schema (bit), and autovacuum. The last one
> is an easy fix, not sure on the others.
I thought you already applied those autovacuum patches? Is there
something else pending for it?
regards, tom lane
Tom Lane wrote:
> Neil Conway <[EMAIL PROTECTED]> writes:
> > The libpq SSL memory leak reported on -bugs would be good to fix.
>
> We don't know yet if that's our bug or not.
>
> > BTW, is there a particular reason we're pushing out 7.4.1 so soon?
> > ISTM there wouldn't be anything wrong with
I recently had the opportunity to take an upper-year/graduate-level
course on DBMS internals at my university. While taking that course, I
wrote some notes on course material as a study aid. I thought that
perhaps some of the people on -hackers might find the notes somewhat
useful, so Bruce was kin
Neil Conway <[EMAIL PROTECTED]> writes:
> The libpq SSL memory leak reported on -bugs would be good to fix.
We don't know yet if that's our bug or not.
> BTW, is there a particular reason we're pushing out 7.4.1 so soon?
> ISTM there wouldn't be anything wrong with waiting a week or two...
Well
Neil Conway wrote:
> "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> > To accomodate ppls travel scheduales, we are going to move the 7.4.1
> > release up to Monday, *unless* there is a report before then about
> > something that needs to be fixed first
>
> The libpq SSL memory leak reported on -
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> To accomodate ppls travel scheduales, we are going to move the 7.4.1
> release up to Monday, *unless* there is a report before then about
> something that needs to be fixed first
The libpq SSL memory leak reported on -bugs would be good to fix.
BTW
On Sat, Dec 06, 2003 at 01:30:02PM -0600, Seum-Lim Gan wrote:
> Hi,
>
> The ident server we currently use is pidentd 3.0.16
> from :
> http://www.lysator.liu.se/ or
> ftp://ftp.lysator.liu.se/pub/ident/servers
The ChangeLog of it says: Solaris 8 (including IPv6) support
added.
But I have a feeli
On Sat, Dec 06, 2003 at 01:30:02PM -0600, Seum-Lim Gan wrote:
> Hi,
>
> The ident server we currently use is pidentd 3.0.16
The only I could find in a short time was oidentd. It says it
runs on Linux, *BSD and Solaris. http://dev.ojnk.net/
I've been told that FreeBSD's inetd's internal identd
Hi,
The ident server we currently use is pidentd 3.0.16
from :
http://www.lysator.liu.se/ or
ftp://ftp.lysator.liu.se/pub/ident/servers
I am looking to see if Solaris has an ident server but have not
found it.
Gan
At 8:21 pm +0100 2003/12/6, Kurt Roeckx wrote:
On Sat, Dec 06, 2003 at 02:09:25PM -
On Sat, Dec 06, 2003 at 02:09:25PM -0500, Tom Lane wrote:
> [ moved to -hackers ]
>
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> We are also wonder if there is a version of Ident server
> >> that the PostgreSQL community knows that will work
> >> with IPv6.
>
> > That is the big question. I
[ moved to -hackers ]
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> We are also wonder if there is a version of Ident server
>> that the PostgreSQL community knows that will work
>> with IPv6.
> That is the big question. I would think Solaris ships with one, but
> maybe not. Is 7.4/Solaris/ident
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> If I'm not wrong Neil Conway is working on
> reimplement a double linked list.
No, he's working on keeping track of the list tail element (and length,
but the tail element is the important part). There was nothing about
double linking.
> In particula
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> In general,
> SELECT count(expr) FROM table1;
> counts the number of rows in table1 where expr evaluates to not null.
Right. Edwin obscured the datatype issue by leaving off a table, but
the issue is real anyway:
regression=# select count(1) from
I could see how this would work if you always had a reference to one of the nodes.
The problem with the approach I can see is that you *have* to always know the value of
at least one pointer, and maintaining that will ultimately require more coding than
just having two pointers.
Assume CurrentNo
Guys, where are we on tablespaces? Should I set up a project page or
does it need organization? I think we need to define the command syntax
and then implementation details. I don't think it is that hard and
certainly is possible for 7.5.
--
Bruce Momjian| http://can
Tom Lane wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> >>> A bug in the information schema concerning the bit types must be
> >>> fixed.
> >>
> >> Does anyone have a patch for this?
>
> > I suppose not, but it's being worked on.
>
> What's the bug exactly? Is it worth delaying the rel
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > What is COUNT('x') supposed to return? 1? Is that legal SQL?
>
> Why not?
Because there is nothing to count.
In general,
SELECT count(expr) FROM table1;
counts the number of rows in table1 where expr evaluates to not null.
If t
If I'm not wrong Neil Conway is working on
reimplement a double linked list.
Looking around I found this post of
"Herb Sutter" on comp.lang.c++:
In particular, a motivation behind two-way pointers is that you
can have a more s
[ General removed, hackers added.]
Where are we on nested transactions. Is it something we can get for 7.5?
---
Manfred Koizar wrote:
> On Wed, 3 Dec 2003 08:08:49 - (GMT), "John Sidney-Woollett"
> <[EMAIL PROTECTED]>
Greg Stark wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
>
> > I hate to reply to this because I have already cast my vote, but
> > "block_size" does not report the size of a disk block. It reports the
> > size of a PostgreSQL block/page. Disk blocks are almost always 512
> > bytes in size.
Bruce Momjian <[EMAIL PROTECTED]> writes:
> What is COUNT('x') supposed to return? 1? Is that legal SQL?
Why not? Vanilla SQL would assume the string is CHAR type.
regards, tom lane
---(end of broadcast)---
TIP 3: if post
Tom Lane wrote:
> [EMAIL PROTECTED] (Edwin S. Ramirez) writes:
> > It appears that the count('x') will no longer work without a type
> > cast. Is this on purpose?
>
> > warehouse=# select count('x') ;
> > ERROR: cannot accept a value of type any
>
> Hm, that query seems like it should be legal.
33 matches
Mail list logo
