The GEQO planner module contains six different recombination algorithms,
only one of which is actually used --- the others are ifdef'd out, and
have been ever since we got the code. Does anyone see a reason not to
prune the deadwood?
regards, tom lane
Tom Lane wrote:
The crash I'm getting can be boiled down to this:
regression=# create table fooey(f1 int) without oids;
CREATE TABLE
regression=# insert into fooey values(11);
INSERT 0 1
regression=# create temp table fooey2 as select distinct * from fooey;
server closed the connection unexpected
The crash I'm getting can be boiled down to this:
regression=# create table fooey(f1 int) without oids;
CREATE TABLE
regression=# insert into fooey values(11);
INSERT 0 1
regression=# create temp table fooey2 as select distinct * from fooey;
server closed the connection unexpectedly
This p
Peter Eisentraut wrote:
> I think "output XML" is just buzz. Give us a real use scenario and an
> indication that a majority also has that use scenario (vs. the other
> ones listed above), then we can talk.
Consider:
create table person (name varchar primary key, age int);
create table account (
we lost a mail relay, so teseting to make sure configuration is still
working after replacing it with other local machines we have more contrl
over ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy
Tom Lane wrote:
> Brian Moore <[EMAIL PROTECTED]> writes:
> > i would like to begin work on the TODO item
> > Allow backend to output result sets in XML
>
> I am not sure why it's phrased that way --- surely the code to hack
> on is the client side, not the backend. Otherwise you need a
> protoc
Please forgive me if this is silly, but if you wanted XML from the server,
couldn't you just write a PL/Perl untrusted function that takes a SELECT
statement as its parameter, and returns a single scalar containing the XML?
- The XML:: modules in Perl help with the XML formatting
- DBD::PgSPI could
Michael Brusser <[EMAIL PROTECTED]> writes:
> So 'rows' values are incorrect.
You sound like you are expecting them to be exact. They're just
estimates. They're all plenty close enough for planning purposes,
except maybe the one for 'KnowledgeBase' is a little further off
than I would have expec
Greg Stark wrote:
Tom Lane <[EMAIL PROTECTED]> writes:
Brian Moore <[EMAIL PROTECTED]> writes:
i would like to begin work on the TODO item
Allow backend to output result sets in XML
I am not sure why it's phrased that way --- surely the code to ha
Greg Stark wrote:
> Personally I don't see any point in xml, but if there was a standard
query
> protocol then a client could send queries to any database that
supported
> it
> without using any libraries. That might be useful. Of course you could
do
> that
> without xml, but people seem to get mor
Tom Lane <[EMAIL PROTECTED]> writes:
> Brian Moore <[EMAIL PROTECTED]> writes:
> > i would like to begin work on the TODO item
> > Allow backend to output result sets in XML
>
> I am not sure why it's phrased that way --- surely the code to hack on
> is the client side, not the backend. Otherw
On Wed, 21 Jan 2004, Michael Brusser wrote:
> So 'rows' values are incorrect.
You can increase the statistics-gathering for that column with ALTER TABLE
and probably get better estimates.
> Also looking at queries with 'KnowledgeBase'
> and 'OtherParam' - does seq. scan make sense?
>
> I mean
> What's the actual distribution of values in these columns?
> Are you searching for values that are particularly common
> or uncommon?
This column always has a predefined set of values.
Usually the app. would search for one of the
existing values.
---
Total records:
On Wed, 21 Jan 2004, Gavin Sherry wrote:
> On Wed, 21 Jan 2004, Christopher Kings-Lynne wrote:
>
> > This is what we did:
> >
> > 0. BEGIN;
> >
> > 1. ALTER TABLE ... SET WITHOUT OIDS
>
> > 12. ROLLBACK;
> >
> > 13. VACUUM FULL forums_posts;
>
> The problem here is that this conditional doesn't ta
On Wed, 21 Jan 2004, Christopher Kings-Lynne wrote:
> This is what we did:
>
> 0. BEGIN;
>
> 1. ALTER TABLE ... SET WITHOUT OIDS
> 12. ROLLBACK;
>
> 13. VACUUM FULL forums_posts;
The problem here is that this conditional doesn't take into account the
change in state which the above transaction c
On Wed, 21 Jan 2004, Christopher Kings-Lynne wrote:
> This seems to be reproducible...
Here is a smaller example that show the problem:
CREATE TABLE foo (a INT);
BEGIN;
ALTER TABLE foo SET WITHOUT OIDS;
INSERT INTO foo values (5);
ROLLBACK;
VACUUM FULL foo;
It's easy to guess what is caus
This is what we did:
0. BEGIN;
1. ALTER TABLE ... SET WITHOUT OIDS
2. A bunch of things are selected out of this table and inserted into
another (using INSERT ... SELECT)
3. An index is created on a timestamp field on this table
4. Then there's an update on a related table, that selects stuff
17 matches
Mail list logo
