Is there a TODO here?
---
Neil Conway wrote:
> Is there a way to recall the previous command in psql? Obviously, "up
> arrow" or Ctrl-P using readline and the default readline bindings is
> close, but it recalls the previo
I was thinking about one of the "pathological cases" where Slony-I
behaves badly, and had an optimization thought...
There is a cleanup loop that (commonly) runs every 10 minutes or so
and vacuums the tables that are used by the replication application.
If there is some long-running transaction k
There is a cleanup loop that (commonly) runs every 10 minutes or so
and vacuums the tables that are used by the replication application.
If there is some long-running transaction kicking around, this will
keep that from actually cleaning things out.
Consider the scenario where the system is prett
On Wed, Feb 23, 2005 at 10:02:22AM +1100, Neil Conway wrote:
> Kenneth Marshall wrote:
> >GEQO is an attempt to provide a near-optimal join order without using
> >an exhaustive search. "An exhaustive, deterministic search of a subset
> >of the search space" has a non-zero probability of finding onl
On Wed, Feb 23, 2005 at 11:39:19PM +0100, Berényi Gábor wrote:
>
> > SELECT usename FROM pg_user WHERE usesuper IS TRUE;
>
> Result: postgres. So the problem persist.
Please show the exact statement you're running and the exact output
(copied and pasted, not typed manually). Also the following,
Kurt Roeckx <[EMAIL PROTECTED]> writes:
> The configure test is a little broken. It needs to quote the
> $'s.
> I've rewritten the test a little.
Applied, thanks.
regards, tom lane
---(end of broadcast)---
TIP 8: explain a
Dear Michael and others,
> SELECT usename FROM pg_user WHERE usesuper IS TRUE;
Result: postgres. So the problem persist.
Does it work for you? I use x86 Linux 2.4.20.
Look forward to hear of you, Gabor
Michael Fuhr <[EMAIL PROTECTED]> írta:
> On Wed, Feb 23, 2005 at 04:53:34PM +0100, Berényi
Thomas F.O'Connell wrote:
Does auto_vacuum vacuum the system tables?
Yes
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Does auto_vacuum vacuum the system tables?
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Feb 16, 2005, at 5:42 PM, Matthew T. O'Connor wrote:
Tom Lane wrote:
[EMAIL PROTECT
On Wed, Feb 23, 2005 at 04:53:34PM +0100, Berényi Gábor wrote:
> After upgrading from 7.4.2 to 8.0.0 I get this message when trying to
> load a C language function:
>
> permission denied for language c
>
> Even postgres and root gets this message. SQL functions work well.
Are you sure "postgre
Dear Pg hackers,
After upgrading from 7.4.2 to 8.0.0 I get this message when trying to
load a C language function:
permission denied for language c
Even postgres and root gets this message. SQL functions work well.
Please, help.
With love, Gabor
---(end of broadcast)-
Tom Lane wrote:
"Keith Worthington" <[EMAIL PROTECTED]> writes:
I have just discovered that I can speed up one of my functions by a factor of
600 by changing an unqualified DELETE to a TRUNCATE. Unfortunately, the
function is run by multiple users and I get the error message
"TESTDB=> TRUNCATE i
On Mon, Feb 21, 2005 at 12:50:44PM +, [EMAIL PROTECTED] wrote:
> host all all 127.0.0.1/0 trust
Should that not be 127.0.0.1/32 ? or even
host all all 127.0.0.1 255.255.255.255trust
?
Patrick
---(end of broadcast)---
TIP 1
13 matches
Mail list logo
