Oleg,
Thanks for your prompt reply.
Actually, I am able to create a new access method for testing and add an
operator class for the type "integer" using the new access method. Then
created a table with two integer fields, one indexed using the new access
method and the other using a btree index, a
Ramy,
glad to hear from you !
AFAIK, posgresql doesnt' supports several indices for the same type.
I think this is a problem of optimizer. Probably other hackers know
better. I forward your message to -hackers mailing list which is a
relevant place for GiST discussion.
regards,
Greg Stark wrote:
>
> Tom Lane <[EMAIL PROTECTED]> writes:
>
> > I'd like to propose that we get rid of GUC's USERLIMIT category and
> > convert all the variables in it to plain SUSET. In my mind, USERLIMIT
> > is a failed experiment: it's way too complicated, and it still doesn't
> > do quite w
Tom Lane <[EMAIL PROTECTED]> writes:
> I'd like to propose that we get rid of GUC's USERLIMIT category and
> convert all the variables in it to plain SUSET. In my mind, USERLIMIT
> is a failed experiment: it's way too complicated, and it still doesn't
> do quite what it was intended to do, becau
Daniel,
concurrency is a big issue of current implementation of GiST.
But it should don't bite you for READ ops !
-hackers mailing list is a very relevant mailing list for GiST
discussions. It's pity we several times claimed to work on GiST
concurrency and recovery, but never got a chance :)
I see
Does anyone know what the expected range of the "penalty" GiST method
is? (i.e. Is the legal range documented anywhere? Failing that, what
does existing GiST-based code expect?)
While rewriting gistchoose() in gist.c to be less obfuscated, it
occurred to me that (a) I don't think the existing code
Hi,
When doing CREATE or REPLACE FUNCTION of a builtin function, it seems to
have no effect if its in the 'C" language. SQL functions seem to work,
but as neilc pointed out, it may be due to the SQL function being
inlined.
The builtin function is still called, not the userdefined function for
'C'
> This doesn't really answer the question of what tool Postgres might
> change to, but it seems that Subversion is a good tool one should
> consider. And by golly, CVS is bad. Just consider the cons – having
> to forbid renames in all but the most necessary cases – it just
> invites cruft into any
I'd like to propose that we get rid of GUC's USERLIMIT category and
convert all the variables in it to plain SUSET. In my mind, USERLIMIT
is a failed experiment: it's way too complicated, and it still doesn't
do quite what it was intended to do, because there are times when it
can't check whether
Robert Treat <[EMAIL PROTECTED]> writes:
> On Tuesday 09 November 2004 11:28, Tom Lane wrote:
>> (One of the potential objections went away when
>> we started enforcing that stable functions don't have side-effects.)
> Since we know people will be calling volatile functions inside stable
> functi
On Tuesday 09 November 2004 11:28, Tom Lane wrote:
> Awhile back, there was some discussion about pre-folding now() and
> related functions when the planner is trying to estimate selectivities.
> This would allow reasonable plans to be made for cases like
> WHERE moddate >= current_date - 10;
> wi
"Ed L." <[EMAIL PROTECTED]> writes:
> A power failure led to failed postmaster restart using 7.4.6 (see output
> below). The short-term fix is usually to delete the pid file and restart.
> I often wonder why ipcs never seems to show the shared memory
> block in question?
> 2004-11-08 17:17:22.39
On Tue, 9 Nov 2004, Tom Lane wrote:
Awhile back, there was some discussion about pre-folding now() and
related functions when the planner is trying to estimate selectivities.
This would allow reasonable plans to be made for cases like
WHERE moddate >= current_date - 10;
without having to in
On Tue, 2004-11-09 at 16:28, Tom Lane wrote:
> Awhile back, there was some discussion about pre-folding now() and
> related functions when the planner is trying to estimate selectivities.
> This would allow reasonable plans to be made for cases like
> WHERE moddate >= current_date - 10;
> wit
On Tue, Nov 09, 2004 at 09:16:34AM +0100, [EMAIL PROTECTED] wrote:
> Could someone be so kind to give me some pointers about how
> to debug pg. I would like to know which debugger you use under windows and
> linux
GDB. The mechanism is simple: start a connection, and in a terminal
window get the
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> I was thinking about organizing the translation files in a more efficient
> manner. (not for 8.0, obviously)
> [snip]
> And it would easily solve issues like translatable strings
> appearing in the pgport library, which has no makefile structure to s
I was thinking about organizing the translation files in a more efficient
manner. (not for 8.0, obviously)
Right now we have one PO file for each combination of program (or library) and
language. The idea was that one only has to install the translation files
for the PostgreSQL pieces that one
Awhile back, there was some discussion about pre-folding now() and
related functions when the planner is trying to estimate selectivities.
This would allow reasonable plans to be made for cases like
WHERE moddate >= current_date - 10;
without having to indulge in any crude hacks with mislab
On Mon, 2004-11-08 at 22:32, Tom Lane wrote:
> Another relevant question is why you are expecting to get this
> information through pgstats and not by looking in the postmaster log.
This is only available if you log all queries, which isn't normally done
while you are in production. When you hit a
Josh Berkus wrote:
Tom,
Another relevant question is why you are expecting to get this
information through pgstats and not by looking in the postmaster log.
I don't know about you, but I don't have any tools that are designed to
cope nicely with looking at tables that have columns that might be ma
On Mon, 2004-11-08 at 21:37, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > Recent runs of DBT-2 show very occasional ExclusiveLock (s) being held
> > by transactions, sometimes waiting to be granted.
>
> I think you are right that these reflect heap or btree-index extension
> opera
Dear Folks,
Could someone be so kind to give me some pointers about how
to debug pg. I would like to know which debugger you use under windows and
linux
Regards,
Gevik
---(end of broadcast)---
TIP 7: don't forget to increase your free space map set
22 matches
Mail list logo