Tom Lane wrote:
I believe the consensus was
* pg_dump and pg_restore should continue to accept -i/--ignore-version
options, to avoid needlessly breaking existing scripts, but these
switches will become no-ops; the version check will occur anyway.
* pg_dump should be fixed to allow server minor
On Sat, Apr 12, 2008 at 10:17 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> > Yes, this is worthless on large active databases. The logging
> > overhead alone starts to affect performance.
>
> But somehow, all that stuff with cached plans is free?
Of course not. The first time you execute a query
I wrote:
> Silent allow is fine with me, I was just wondering if anyone liked
> the other options better.
Okay, I'm back on the warpath about this after noting yet another user
who thinks he should use -i mindlessly:
http://archives.postgresql.org/pgsql-admin/2008-04/msg00111.php
I believe the co
"Jonah H. Harris" <[EMAIL PROTECTED]> writes:
> On Sat, Apr 12, 2008 at 2:19 PM, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
>> There are other benefits as well. Oracle lets you see the statistics
>> associated
>> with given plans. So you can see how many times given (cached) query was
>> executed
On Sat, Apr 12, 2008 at 2:19 PM, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> There are other benefits as well. Oracle lets you see the statistics
> associated
> with given plans. So you can see how many times given (cached) query was
> executed, how much resources did it consume and do on.
Y
On Sat, Apr 12, 2008 at 8:44 AM, Perez <[EMAIL PROTECTED]> wrote:
> Doesn't Oracle do this now transparently to clients?
Of course it does, and it has since the late 80's I believe.
> Oracle keeps a statement/plan cache in its shared memory segment (SGA)
> that greatly improves its performance
On Fri, Apr 11, 2008 at 12:34 PM, PFC <[EMAIL PROTECTED]> wrote:
> Well, I realized the idea of global prepared statements actually
> sucked, so I set on another approach thanks to ideas from this list, this is
> caching query plans.
Well, that's a blatantly bad realization. Perhaps you s
On Sat, Apr 12, 2008 at 3:53 AM, Dickson dos Santos Guedes
<[EMAIL PROTECTED]> wrote:
> Well, working in the latest revision from CVS I added a feature for
> psql to the command "\d+", now it shows the object size as like as
> "\l+" show the database size.
>
I was going to try this patch out, b
=?ISO-8859-1?Q?Alexander_W=F6hrer?= <[EMAIL PROTECTED]> writes:
> I will try my luck anyway and try to built PostGre 8.3 without
> check_stack_depth doing anything - will let you know what happens for my
> application.
It will crash ... but perhaps not until after it's hopelessly corrupted
your
Alexander Wöhrer <[EMAIL PROTECTED]> writes:
> Dear Gregory,
>
> Thank you very much for you fast answer and your tips.
> What is meant by IIUC?
"if I understand correctly"
> Actually just one thread is accessing the database - the two others do
> send/recieve data.
Then in theory it should wor
Dear Gregory,
Thank you very much for you fast answer and your tips.
What is meant by IIUC?
Actually just one thread is accessing the database - the two others do
send/recieve data.
I will try my luck anyway and try to built PostGre 8.3 without
check_stack_depth doing anything - will let you
I looked over the issue of making the regular-indexscan code path able
to handle runtime determination of operator lossiness. Here's my
implementation plan:
* Extend amgettuple API to allow a boolean recheck flag to be passed back.
* Remove index_getnext_indexitem, which is dead code and has bee
Alexander Wöhrer <[EMAIL PROTECTED]> writes:
> by Thomas Hallgren where he mentioned that PostGre only defines
> one stack and therefor pl/java has no way of telling PostGre
> about multiple thread stack pointers.
>
> As far as I understand the situation, the check_stack_depth()
> is used "just"
Dear PostGre developers,
I'm working on Windows XP SP2 (stack limit set to 3500 kb) and deployed
successfully my Java application (doing some external Web service calling)
inside PostGre 8.3.0.
Unfortunatelly, the application needs at least 3 Threads and will run
for quite some time.
I fou
On Sat, Apr 12, 2008 at 2:44 PM, Perez <[EMAIL PROTECTED]> wrote:
> In article <[EMAIL PROTECTED]>,
>
> > PFC wrote:
> >
> > > So, where to go from that ? I don't see a way to implement this
> without
> > > a (backwards-compatible) change to the wire protocol, because the clients
> > > wi
"Simone Campora" <[EMAIL PROTECTED]> writes:
> I first want to implement it and to make it works, like this:
> SPGIST_FUNCTION(pquad_equals_op)
> {
> elog (NOTICE, "1");
> Point *p1 = (Point *)PG_GETARG_POINTER(0);
> Point *p2 = (Point *)PG_GETARG_POINTER(1);
> elog (NOTICE, "2")
Hello to all of you! I'm new of this newsletter but I hope that this is the
good place to send this help request!
I'm a student and I'm developing a quadtree index using postgresql 8.0.15
under Linux Ubuntu 7.10 Gusty Gibbon, but I have the following problem:
I downloaded the GIST extension SPGIS
In article <[EMAIL PROTECTED]>,
> PFC wrote:
>
> > So, where to go from that ? I don't see a way to implement this without
> > a (backwards-compatible) change to the wire protocol, because the clients
> > will want to specify when a plan should be cached or not. Since the user
> > should
Hannu Krosing wrote:
index tree node binary mask mask bits
00 0
10-1? 1
21 1
30-3000?? 2
42 00010
52-30001?
Well if you're caching per-connection then it doesn't really matter
whether
you do it on the client side or the server side, it's pretty much
exactly the
same problem.
Actually I thought about doing it on the server since it would then also
work with connection pooling.
Doi
--On Freitag, April 11, 2008 13:53:11 -0500 Decibel! <[EMAIL PROTECTED]>
wrote:
As Bernd said, I see this as simple search and replace, and then stick it
in the command buffer. If you define an alias that calls itself, you
could end up with a stack overflow, same as with server functions.
The
I'm just an observer here, but I thought I'd present an idea. Feel free to
tell me I'm nuts if you don't like it.
It seems to me that there are two main concerns in this area on discussion:
1. How to create a list of patches/review items/etc without adding a
significant amount of noise to this li
On Sun, Mar 30, 2008 at 9:39 AM, Brendan Jurd <[EMAIL PROTECTED]> wrote:
> On 25/03/2008, Tom Lane <[EMAIL PROTECTED]> wrote:
> > "Brendan Jurd" <[EMAIL PROTECTED]> writes:
> > > This makes me wonder whether print.c could offer something a bit more
> > > helpful to callers wishing to DIY a tab
23 matches
Mail list logo
