> From: Tom Lane <[EMAIL PROTECTED]>
>
> You've provided no evidence that this is a bad plan.
>
Looks like I didn't take the time to understand properly what the explains were
showing.
> In particular, the plan you seem to think would be better
> would involve
> an estimated 153 iterations of
On Tue, Dec 02, 2008 at 05:35:35PM +0530,
ravi kiran <[EMAIL PROTECTED]> wrote
a message of 19 lines which said:
> I am using the psqlodbc driver to connect to postgresql... But this
> is not supporting all the languages that UTF should support..
An important thing: the Unicode character set,
WireSpot wrote:
> This mechanism is still not perfect. Technically it is still possible
> for race conditions to appear. Apparently (in PHP at least) pg_connect
> does persistent connections by default.
Nope - pg_pconnect() does that. Multiple calls to pg_connect() within
the same script will give
Hi,
I have a table with a lot of columns (text and integer).
It currently has 3Mio Rows.
Updating a column in all rows (integer) takes endless (days).
The column I update is not indexed.
How can I tune postgres to do this much more quickly?
VMstat looks like this:
r b swpd free buff
中和刘 wrote:
> I have just installed postgresql 8.3 on my debian sid, and have set
> the password of both system user postgres and database user to the
> same password, but when i connect to it using pgadmin3(from the local
> machine), i got the error:
> here is the log messages
> --
On Sun, Dec 07, 2008 at 02:36:56PM -0500, Jaime Casanova wrote:
> Hi,
>
> any one has doing this... is there a good tutorial o directions for it?
The answer to this is highly dependent on the system you're using.
What is it?
A
--
Andrew Sullivan
[EMAIL PROTECTED]
--
Sent via pgsql-general m
try rewriting it to something like:
update users set price = p.price from prices p where p.type =
'normal_price' and p.currency = users.currency;
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-g
Hi everyone,
I am one of the developers for TurnKey Linux, a new opensource project
that develops a family of lightweight installable live CDs optimized for
various server-type tasks including LAMP, Ruby on Rails, Django, Joomla,
Drupal, MediaWiki, and others:
http://www.turnkeylinux.org/applianc
2008/12/8 Grzegorz Jaśkiewicz <[EMAIL PROTECTED]>
> try rewriting it to something like:
>
> update users set price = p.price from prices p where p.type =
> 'normal_price' and p.currency = users.currency;
also avoid "fake" updates:
update users set price = p.price from prices p where p.type =
'n
On Mon, Dec 8, 2008 at 3:28 AM, Sebastian Böhm <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a table with a lot of columns (text and integer).
>
> It currently has 3Mio Rows.
>
> Updating a column in all rows (integer) takes endless (days).
I'm afraid you may not understand how postgresql's MVCC imp
On Mon, Dec 8, 2008 at 7:06 AM, Liraz Siri <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I am one of the developers for TurnKey Linux, a new opensource project
> that develops a family of lightweight installable live CDs optimized for
> various server-type tasks including LAMP, Ruby on Rails, Djang
On Sat, Dec 6, 2008 at 7:36 AM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
>> itidb=> update joblist set (full_name, email_address, recruiter,
>> itidb(> subscribed, verified, created_at, updated_at) =
>> itidb-> ('[name hidden]', '[email address hidden]', false, true
>> itidb(> true, current_t
"Richard Broersma" <[EMAIL PROTECTED]> writes:
> Does this mean the PostgreSQL supports row-wise updates? When did this
> happen?
Only sort of ...
http://archives.postgresql.org/pgsql-committers/2006-09/msg00021.php
I didn't want this applied
http://archives.postgresql.org/pgsql-patches/2006-07
> This sounds great. If I wind up with a big machine to test it on I'll
> tell you how it goes.
Thanks, though you don't necessarily have to wait for a "big machine" if
you just want to give the appliance a go. A little machine or even a
virtual machine should do.
> Are you familiar with this bu
Thanks all
On 12/7/08, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Josh Harrison" <[EMAIL PROTECTED]> writes:
>> How can I give the ALTER permission
>
> You can't grant ALTER permission --- that's only allowed to the table
> owner. However, you could make thw table be owned by a group role and
> grant
On Mon, Dec 8, 2008 at 10:47 AM, Liraz Siri <[EMAIL PROTECTED]> wrote:
>> This sounds great. If I wind up with a big machine to test it on I'll
>> tell you how it goes.
>
> Thanks, though you don't necessarily have to wait for a "big machine" if
> you just want to give the appliance a go. A little
Greetings,
I've just run up against a problem with ALTER LANGUAGE ... OWNER
TO ... wherein the change of ownership does not propagate to a
language's handler and validator functions preventing you from
dropping the role if it created a language. I'm assuming a valid
workaround is manuall
Erik Jones <[EMAIL PROTECTED]> writes:
> I've just run up against a problem with ALTER LANGUAGE ... OWNER
> TO ... wherein the change of ownership does not propagate to a
> language's handler and validator functions preventing you from
> dropping the role if it created a language. I'm assumi
I upgraded the distribution on my system and am now having problems
opening a local application. /var/log/apache/error.log shows:
Error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.
On Mon, 8 Dec 2008, Rich Shepard wrote:
I upgraded the distribution on my system and am now having problems
opening a local application. /var/log/apache/error.log shows:
More insight. When I stop the postmaster I see this:
[EMAIL PROTECTED] ~]# /etc/rc.d/rc.postgresql stop
Shutting down P
Hello Guys,
The following is my sample program
result R(T.exec("select * from emp"));
string L;
stringstream S;
vector v;
int z,i;
z = R.size();
for (i = 0;i> L;
v.push_back(L);
}
There is a table emp with single column,while I am working on this module I
encountere
Hi all,
I've got a table that I am trying to SELECT DISTINCT on one column
and ORDER BY on a second column, but am getting the error:
SELECT DISTINCT ON expressions must match initial ORDER BY expressions
I can't add the second column to the DISTINCT clause because every
row is unique. L
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Madison Kelly
> Sent: 08 December 2008 22:19
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] SELECT DISTINCT ... ORDER BY problem
>
> Hi all,
>
>I've got a table that I am tr
Rich Shepard wrote:
> On Mon, 8 Dec 2008, Rich Shepard wrote:
>
>> I upgraded the distribution on my system and am now having problems
>> opening a local application. /var/log/apache/error.log shows:
>
> More insight. When I stop the postmaster I see this:
>
> [EMAIL PROTECTED] ~]# /etc/rc.d/rc.
David Rowley wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Madison Kelly
Sent: 08 December 2008 22:19
To: pgsql-general@postgresql.org
Subject: [GENERAL] SELECT DISTINCT ... ORDER BY problem
Hi all,
I've got a table that I am
On Mon, Dec 08, 2008 at 11:16:29PM -, David Rowley wrote:
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:pgsql-general-
> > [EMAIL PROTECTED] On Behalf Of Madison Kelly
> > Sent: 08 December 2008 22:19
> > To: pgsql-general@postgresql.org
> > Subject: [GENERAL] SELECT DISTIN
On Mon, 8 Dec 2008, Alvaro Herrera wrote:
Wow. Is this Gentoo by chance?
Alvaro,
Nope. It's Slackware-12.1, and not being at all gentle.
I had this happen several years ago, but do not recall what fixed the bad
PID file and socket. The thread had been saved here, but I must have
inadver
David Fetter wrote:
On Mon, Dec 08, 2008 at 11:16:29PM -, David Rowley wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Madison Kelly
Sent: 08 December 2008 22:19
To: pgsql-general@postgresql.org
Subject: [GENERAL] SELECT DISTINC
> -Original Message-
> From: David Fetter [mailto:[EMAIL PROTECTED]
> Sent: 09 December 2008 00:55
> To: David Rowley
> Cc: 'Madison Kelly'; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] SELECT DISTINCT ... ORDER BY problem
>
> On Mon, Dec 08, 2008 at 11:16:29PM -, David Rowley
Madison Kelly Wrote:
> David Fetter wrote:
> > On Mon, Dec 08, 2008 at 11:16:29PM -, David Rowley wrote:
> >>> -Original Message-
> >>> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> >>> [EMAIL PROTECTED] On Behalf Of Madison Kelly
> >>> Sent: 08 December 2008 22:19
> >>> To: pgsql-ge
> >
> > When we get windowing functions, a lot of this pain will go away :)
> >
>
> Yes! Hope it won't be too long now. The patch seems to behave like it
> should
> now :)
> Hopefully we'll see it commited for 8.4.
>
> Though this does not look too much cleaner at least it's standard SQL:
>
> A
On Mon, Dec 8, 2008 at 8:16 PM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> 中和刘 wrote:
>> I have just installed postgresql 8.3 on my debian sid, and have set
>> the password of both system user postgres and database user to the
>> same password, but when i connect to it using pgadmin3(from the loca
Iwant quit this milis. could you help me? I forget my milis password.
Selalu bisa chat di profil jaringan, blog, atau situs web pribadi! Yahoo!
memungkinkan Anda selalu bisa chat melalui Pingbox. Coba!
http://id.messenger.yahoo.com/pingbox/
--
Sent via pgsql-general mailing list (pg
Tonny Sapri wrote:
Iwant quit this milis. could you help me? I forget my milis password.
go to this web site http://www.postgresql.org/mailpref/pgsql-general
click "Sign In" at the top left.
find the section that says "Lost Password".
put your email address in there and click the "Mail My
I am trying to get the following program to compile the following program
with Embedded SQL Processor:
#include
main()
{
printf( "I am alive\n" );
#if 0
EXEC SQL CONNECT TO DEFAULT;
#endif
printf( "status is %d\n", sqlca.sqlcode );
}
I am doing this as
On Mon, 8 Dec 2008, Rich Shepard wrote:
I had this happen several years ago, but do not recall what fixed the bad
PID file and socket. The thread had been saved here, but I must have
inadvertenly deleted it.
Figured out how to fix the problem, but still cannot get SQL-Ledger to
load. Time t
Rich Shepard wrote:
On Mon, 8 Dec 2008, Rich Shepard wrote:
> I had this happen several years ago, but do not recall what fixed the bad
> PID file and socket. The thread had been saved here, but I must have
> inadvertenly deleted it.
Figured out how to fix the problem, but still cannot get
On Tue, 9 Dec 2008, Klint Gore wrote:
How did you fix it? (so its filed in the archive)
klint,
I removed the 'stale' .pid file, then manually started the postmaster (su
postgres -c 'postgres -D /var/lib/pgsql/data &') rather than using the
Slackware startup script (/etc/rc.d/rc.postgresql)
On Mon, 8 Dec 2008, Scott Marlowe wrote:
Are you familiar with this bug:
https://bugs.launchpad.net/debian/+source/linux/+bug/245779
It's the reason my latest db servers are running Centos 5.2, sadly.
By the time I'd found the suggested workaround of setting a boot
option of NO_HZ=y I was alrea
39 matches
Mail list logo
