Hello Alvaro, Hello Tom,
thank you very much for your quick and helpful replies.
> You can always cast pretty much anything to anything via a variable
> assignment in plpgsql...
I only tried it in SQL. So the function works just fine after the
removal of the text cast on 8.2 as well.
For SQL
You don't have accurate stats over that table.
Try this after deleting:
VACUUM ANALYZE test2;
I suggest to activate autovacuum in your postgresql.conf, so you won't
have to analyze table by hand.
-Original Message-
From: Kumar Anand
To: pgsql-admin@postgresql.org
Subject: [ADMIN] select
Hello,
I have a working warm standby system, running 8.4 (thanks for urging
me to upgrade from the rehdat provided release).
One of the new requirements is going to be for (a non-DBA) admin to
easily swap services between the two servers for maintenance.
The first move runs easily as expected- po
On Thu, Aug 20, 2009 at 3:36 AM, Kumar Anand wrote:
> Dear all,
>
> I face this problem from last few days.
>
> here is test2 table with only one column id
> erp_test=> \d test2
> Table "public.test2"
> Column | Type | Modifiers
> +-+---
> id | integer |
>
> I ins
We have a two node cluster and we are planning on adding a third.
Question is, we want the third machine to be more robust, thus we want
more memory, hence we would like to run 64bit.
Will this be a problem if our two current clustered machines are 32bit?
Our data resides on a fiber connecte
On Fri, Aug 21, 2009 at 11:42 AM, Geoffrey wrote:
> We have a two node cluster and we are planning on adding a third. Question
> is, we want the third machine to be more robust, thus we want more memory,
> hence we would like to run 64bit.
>
> Will this be a problem if our two current clustered ma
On Fri, Aug 21, 2009 at 11:42 AM, Geoffrey wrote:
> We have a two node cluster and we are planning on adding a third.
P.s. what do you mean by two node cluster? What software are you
using to do this?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subs
Hello,
The new option to define a background color for each server in PgAdmin
1.10 is very cool (to distinguish test servers from production servers).
It would be very nice to have a reminder of this background color in the
query module.
Best Regards,
Benoit Pesty
Hi Benoit,
Hello,
The new option to define a background color for each server in PgAdmin
1.10 is very cool (to distinguish test servers from production servers).
It would be very nice to have a reminder of this background color in
the query module.
You might like to post this q
