Mark Kirkwood wrote:
I'm seeing a segfault on a size TPC-H size 10 database. The patch and
code are:
- bitmap patch from 12 Mar
- 8.3 dev from 27 Mar
SELECT count(distinct(o_orderkey))
FROM orders orders_alias
WHERE o_orderpriority IN ('1-URGENT', '3-MEDIUM') AND o_orderstatus='P';
(gdb) bt
#
Via signal handling? Use the kill() function (or its pg equivalent) to send
the appropriate signal?
On 4/6/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Aleksis Petrov" <[EMAIL PROTECTED]> writes:
> Would it be acceptable to invoke pg_ctl in the API functions to stop and
> restart the server?
No.
"Aleksis Petrov" <[EMAIL PROTECTED]> writes:
> Would it be acceptable to invoke pg_ctl in the API functions to stop and
> restart the server?
No. Not everyone uses pg_ctl for that.
regards, tom lane
---(end of broadcast)---
Hi all,
Would it be acceptable to invoke pg_ctl in the API functions to stop and
restart the server?
thanks
"Gurjeet Singh" <[EMAIL PROTECTED]> writes:
> Please find attached the latest version of the patch. It applies cleanly on
> REL8_2_STABLE.
The interface to the planner in this seems rather brute-force. To run
a plan involving a hypothetical index, you have to make a bunch of
catalog entries, run
Tom Lane wrote:
> "=?ISO-8859-1?Q?Ott=F3_Havasv=F6lgyi?=" <[EMAIL PROTECTED]> writes:
>
>> When using views built with left joins, and then querying against these
>> views, there are a lot of join in the plan that are not necessary, because I
>> don't select/use any column of each table in the v
Tzahi Fadida <[EMAIL PROTECTED]> writes:
> This is an excerpt from my code:
> newtset->tids = (bytea *) fastgetattr(tupleTSet, LABELS_ALIGNED,
> fctx->tupleSetDesc, &isnull);
> It seems that for an empty bytea (only the size of the header), i get that
> VARSIZE(newtset->tids)==534765440
> instea
Hi,
I am having trouble with fixing my code for this recent varlena patch:
http://archives.postgresql.org/pgsql-committers/2007-04/msg00081.php
My module is fulldisjunctions.
I have several problems but first i wish to address the following.
This is an excerpt from my code:
newtset->tids = (bytea
"=?ISO-8859-1?Q?Ott=F3_Havasv=F6lgyi?=" <[EMAIL PROTECTED]> writes:
> When using views built with left joins, and then querying against these
> views, there are a lot of join in the plan that are not necessary, because I
> don't select/use any column of each table in the views every time. Tables
>
Zdenek Kotala <[EMAIL PROTECTED]> writes:
> It sounds good. There is one think for clarification (for the present).
> How to handle buffile? It does not currently support non segmented
> files. I suggest to use same switch to enable/disable segments there.
Do you think it really matters? teraby
Hi,
When using views built with left joins, and then querying against these
views, there are a lot of join in the plan that are not necessary, because I
don't select/use any column of each table in the views every time. Tables
that are left joined and never referenced anywhere else in the query
Tom Lane wrote:
[ redirecting to -hackers for wider comment ]
Zdenek Kotala <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
LET_OS_MANAGE_FILESIZE is good way. I think one problem of this option I
fixed. It is size of offset. I went thru the code and did not see any
other problem there. However,
Florian G. Pflug wrote:
> Hi
>
> Does anyone know if pgsnmpd is still actively developed?
> The last version (0.1b1) is about 15 months old.
It is.
There is a team (Josh Tolley, me and Hiroshi Saito) working for RFC 1697
compliance. When that's done, there are some other additions in the
pipeline
On Fri, 2007-04-06 at 16:08 +0200, Markus Schiltknecht wrote:
> Simon Riggs wrote:
> > i.e. if we have partitions for each year (2001, 2002, 2003 2004, 2005,
> > 2006, 2007) AND we have already proved that 2005 is excluded when we
> > have a WHERE clause saying year >= 2006, then we should be able
Florian G. Pflug wrote:
> Hi
>
> Does anyone know if pgsnmpd is still actively developed?
> The last version (0.1b1) is about 15 months old.
there seems to be quite a lot of work going on in the cvs tree:
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgsnmpd/pgsnmpd/
so i would guess it is still
Hi
Does anyone know if pgsnmpd is still actively developed?
The last version (0.1b1) is about 15 months old.
greetings, Florian Pflug
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
> David Fetter wrote:
> > On Fri, Apr 06, 2007 at 09:22:55AM -0700, Joshua D. Drake wrote:
> >
> >>> The people that use it are the people stuck by dogmatic rules about
> >>> "every table must have a primary key" or "every logical constraint
> >>> must be protected by a database constraint". Ie, d
[ redirecting to -hackers for wider comment ]
Zdenek Kotala <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
> LET_OS_MANAGE_FILESIZE is good way. I think one problem of this option I
> fixed. It is size of offset. I went thru the code and did not see any
> other problem there. However, how you men
Tom Lane wrote:
FWIW, I think we are more in need of coverage of different configure-option
sets than of OS's per se.
If someone would like to put together a list of gaps we can see what we
can do about it.
For anyone who wants the data on what is being built currently, the
dashboard
Stuart Bishop <[EMAIL PROTECTED]> writes:
> After a test is run, the test harness kills any outstanding connections so
> we can drop the test database. Without this, a failing test could leave open
> connections dangling causing the drop database to block.
Just to make it perfectly clear: we don't
David Fetter wrote:
On Fri, Apr 06, 2007 at 09:22:55AM -0700, Joshua D. Drake wrote:
The people that use it are the people stuck by dogmatic rules about
"every table must have a primary key" or "every logical constraint
must be protected by a database constraint". Ie, database shops run
by the
On Fri, Apr 06, 2007 at 09:22:55AM -0700, Joshua D. Drake wrote:
> >The people that use it are the people stuck by dogmatic rules about
> >"every table must have a primary key" or "every logical constraint
> >must be protected by a database constraint". Ie, database shops run
> >by the CYA princip
Larry Rosenman writes:
> I'd still like to hear from a Tom Lane or someone else on the project with
> what
> X86 or X86_64 OS's we need coverage for.
FWIW, I think we are more in need of coverage of different configure-option
sets than of OS's per se.
regards, tom lane
But if we could find a way to represent that it would make a lot of common use
cases much more convenient to use.
(But that sounds rather like pie in the sky, actually. Which other
databases can do that, and how do they do it?)
Oracle does it, by building a big index. Few people use it.
Th
Mark Shuttleworth wrote:
> Tom Lane wrote:
>> (1) something (still not sure what --- Martin and Mark, I'd really like
>> to know) was issuing random SIGTERMs to various postgres processes
>> including autovacuum.
>>
>
> This may be a misfeature in our test harness - I'll ask Stuart Bishop to
>
On 4/5/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
Nikolay Samokhvalov wrote:
[...]
> If I am wrong and it's better to leave libxml2-free capabilities, then
IMHO
> we need to reflect it explicitly in the docs, what requires libxml2, and
> what doesn't
Agreed, let's do the later and update the
Tom Lane wrote:
> (1) something (still not sure what --- Martin and Mark, I'd really like
> to know) was issuing random SIGTERMs to various postgres processes
> including autovacuum.
>
This may be a misfeature in our test harness - I'll ask Stuart Bishop to
comment.
Mark
> --- Original Message ---
> From: Stefan Kaltenbrunner <[EMAIL PROTECTED]>
> To: Andrew Dunstan <[EMAIL PROTECTED]>
> Sent: 06/04/07, 15:33:20
> Subject: Re: [HACKERS] What X86/X64 OS's do we need coverage for?
>
> yeah improving windows coverage might be a nice thing - some other
I'm
VMWare Server is indeed a fine product, which I use extensively.
I am not sure what our Windows support is like for x86_64. Magnus has
one for MSVC (for which buildfarm support is nearly done, but not
quite). But I don't see one for MinGW. OTOH, Windows is not free (in
either sense) and setting
On Fri, 6 Apr 2007, Stefan Kaltenbrunner wrote:
Andrew Dunstan wrote:
Larry Rosenman wrote:
It doesn't matter as far as MY box is concerned. I use VMWare
extensively
in my current $DAYJOB, and I want to be able to test/play with things
related
to that as well. The box I'm building will be
On Fri, 6 Apr 2007, Andrew Dunstan wrote:
Larry Rosenman wrote:
It doesn't matter as far as MY box is concerned. I use VMWare extensively
in my current $DAYJOB, and I want to be able to test/play with things
related
to that as well. The box I'm building will be using the (free) VMWare
Ser
Zeugswetter Andreas ADI SD wrote:
(But that sounds rather like pie in the sky, actually. Which other
databases can do that, and how do they do it?)
Oracle does it, by building a big index. Few people use it.
And others allow a different partitioning strategy for each index,
but that has the s
Andrew Dunstan wrote:
>
>
> Larry Rosenman wrote:
>> It doesn't matter as far as MY box is concerned. I use VMWare
>> extensively
>> in my current $DAYJOB, and I want to be able to test/play with things
>> related
>> to that as well. The box I'm building will be using the (free) VMWare
>> Serve
Larry Rosenman wrote:
It doesn't matter as far as MY box is concerned. I use VMWare
extensively
in my current $DAYJOB, and I want to be able to test/play with things
related
to that as well. The box I'm building will be using the (free) VMWare
Server
as it's virtualization platform.
I'd s
Simon Riggs wrote:
i.e. if we have partitions for each year (2001, 2002, 2003 2004, 2005,
2006, 2007) AND we have already proved that 2005 is excluded when we
have a WHERE clause saying year >= 2006, then we should be able to use
the ordering to prove that partitions for 2004 and before are also
On Fri, 6 Apr 2007, Matthew O'Connor wrote:
Devrim G??nd??z wrote:
Hi,
On Fri, 2007-04-06 at 01:23 -0400, Matthew T. O'Connor wrote:
The other thing to consider is that CentOS 5 has Xen built right in,
so you should be able run VMs without VMWare on it.
... if the kernel of the OS has Xen
On Fri, 2007-04-06 at 12:47 +0200, Zeugswetter Andreas ADI SD wrote:
> What I think we would like to have is putting the append nodes into an
> order that allows removing the sort node whenever that can be done.
> And
> maybe a merge node (that replaces the append and sort node) that can
> merge pr
Patch committed. Thanks.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
> The attached is a patch to optimize contrib/pgbench using new 8.3 features.
>
> - Use DROP IF EXISTS to suppress errors for initial loadings.
> - Use a combination of TRUNCATE and COPY to reduce WAL on creating
> the accounts table.
> On Fri, 6 Apr 2007, Tatsuo Ishii wrote:
>
> > 1) latency log file format extention looks usefull (-x option).
> > 2) it seems the "cleanup feature" (-X option) was withdrawed by the
> > author, but the patches still include the feature. So I'm confused.
>
> The patch I sent to the mailing lis
On Thu, Apr 05, 2007 at 06:28:39PM -0500, Larry Rosenman wrote:
> I might use that as the base then, since the hardware finishes getting here
> tomorrow.
>
> My question still stands on what OS's we need coverage for.
I can provide coverage of SuSE Enterprise 9/10 on i386/x86_64. I just
filled o
> > (But that sounds rather like pie in the sky, actually. Which other
> > databases can do that, and how do they do it?)
>
> Oracle does it, by building a big index. Few people use it.
And others allow a different partitioning strategy for each index,
but that has the same problem of how to r
Hi,
... if the kernel of the OS has Xen support, there will be no
performance penalty (only 2%-3%) (Para-virtualization). Otherwise, there
will be full-virtualization, and we should expect a performance loss
about 30% for each guest OS (like Windows).
I may be wrong but I thought that the gues
Devrim Gündüz wrote:
Hi,
On Fri, 2007-04-06 at 01:23 -0400, Matthew T. O'Connor wrote:
The other thing to consider is that CentOS 5 has Xen built right in,
so you should be able run VMs without VMWare on it.
... if the kernel of the OS has Xen support, there will be no
performance penalty (o
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> If we partition on invoice_date only, there is an implication that
> people will search for invoices on date range only too, otherwise why
> not just partition on invoice_id. This still works with the compound key
> approach.
Well there are practical pr
On Fri, 2007-04-06 at 01:56 -0400, Tom Lane wrote:
> Markus Schiltknecht <[EMAIL PROTECTED]> writes:
> > Uh.. can you elaborate on that? AFAICS, you would simply have to query
> > multiple btree indexes and make sure non of them is violated.
>
> That only works for the partition-key indexes, ie,
Suresh wrote:
Hi,
I want to get the coding details regarding postgres optimizer.
Essentially, which files correspond to which functions, how the algo is
implemented, the flow etc.. Where can I find this material ?
Maybe start with the docs, there a good section on optimization:
http://www
On 4/6/07, Larry Rosenman wrote:
I am willing to run any X86 or X64 OS's in VM's as buildfarm clients.
What OS's do we need coverage for?
Cannot say about OS, but could you run it with
Python 2.5? 64bit interface changed there and it
would be interesting to see if it still works.
--
marko
Martijn van Oosterhout wrote:
> So your implemntation is simply:
> 1. Take number and make UTF-8 string
> 2. Convert it to database encoding.
Aah, now I can spot where the misunderstanding is.
That's not what I mean.
I mean that chr() should simply 'typecast' to "char".
So when the database enco
48 matches
Mail list logo
