Re: [GENERAL] Large temporary file generated during query

On Fri, Dec 7, 2012 at 1:58 PM, Ryan Kelly wrote: > I have a very large query that also touches quite a bit of data. It > generates a large temporary file (actually, several, because the total > size is about 4.5GB). I'm wondering which part of the query's plan > causes these files to be created.

Re: [GENERAL] How to mix psql commands and SQL commands on the shell command line?

Thank you very much, Adrian and Pavel. And I really appreciate the documentation reference, Adrian! Yours fondly, Aleksey -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Large temporary file generated during query

I have a very large query that also touches quite a bit of data. It generates a large temporary file (actually, several, because the total size is about 4.5GB). I'm wondering which part of the query's plan causes these files to be created. The query has the following sequence of plan nodes when run

Re: [GENERAL] unlooged tables

Hi, On 2012-12-07 14:29:26 +, Igor Neyman wrote: > I was hoping, may be hacking pg_catalog, like setting pg_class.relpersistence > to 'u' will do the trick (or something like this). > > b.t.w. there will be no other active connections, so there is no risk of > needing to add/update/delete re

Re: [GENERAL] unlooged tables

On Fri, Dec 7, 2012 at 6:29 AM, Igor Neyman wrote: >> -Original Message- >> From: Sergey Konoplev [mailto:gray...@gmail.com] >> Sent: Thursday, December 06, 2012 4:52 PM >> To: Igor Neyman >> Cc: pgsql-general@postgresql.org >> Subject: Re: [GENERAL] unlooged tables >> >> Hi, >> >> On Thu,

Re: [GENERAL] How to mix psql commands and SQL commands on the shell command line?

Hello 2012/12/7 Aleksey Tsalolikhin : > How can I mix psql commands and SQL commands on the shell command line, > please? > > $ psql > psql (9.2.1) > Type "help" for help. > > ddcKeyGen=> \timing \\ select count(*) from auth_users; > Timing is on. > count > --- >276 > (1 row) > > Time: 1

Re: [GENERAL] How to mix psql commands and SQL commands on the shell command line?

On 12/07/2012 11:58 AM, Aleksey Tsalolikhin wrote: How can I mix psql commands and SQL commands on the shell command line, please? $ psql psql (9.2.1) Type "help" for help. ddcKeyGen=> \timing \\ select count(*) from auth_users; Timing is on. count --- 276 (1 row) Time: 1.730 ms $ p

[GENERAL] How to mix psql commands and SQL commands on the shell command line?

How can I mix psql commands and SQL commands on the shell command line, please? $ psql psql (9.2.1) Type "help" for help. ddcKeyGen=> \timing \\ select count(*) from auth_users; Timing is on. count --- 276 (1 row) Time: 1.730 ms $ psql -c "\timing \\ select count(*) from auth_users;" Ti

Re: [GENERAL] logs encoding problem Windows

Bartosz Dmytrak writes: > I've got a question about logs encoding on Windows. Postmaster log messages are written in whatever the database_encoding is, so if you've got multiple databases with different encodings, the encoding in the log will be inconsistent. There have been debates about fixing

Re: [GENERAL] How to find which query a waiting query waiting for?

On Fri, Dec 7, 2012 at 1:02 PM, wd wrote: > hi, > > From pg_stat_activity I can find a query is at waiting state, and from > pg_locks and pg_class can find which relation the query is waiting for, But > how to find witch query is lock the relation? > Maybe you found what you need here [1]. [1]

Re: [GENERAL] How to find which query a waiting query waiting for?

On Fri, Dec 07, 2012 at 11:02:33PM +0800, wd wrote: > From pg_stat_activity I can find a query is at waiting state, and from > pg_locks and pg_class can find which relation the query is waiting for, But > how to find witch query is lock the relation? sipmply check which query has lock on the relat

[GENERAL] How to find which query a waiting query waiting for?

hi, >From pg_stat_activity I can find a query is at waiting state, and from pg_locks and pg_class can find which relation the query is waiting for, But how to find witch query is lock the relation?

Re: [GENERAL] Backend process is still runs even postmaster got killed

On Fri, Dec 7, 2012 at 10:21 AM, Alvaro Herrera wrote: >>Hari Babu wrote: >> Backend processes are still running even if the postmaster got killed and >> all other server processes are exited by checking the >> >> Postmaster status. >What server version? I had tested it in 9.3 devel and 9.2 as

Re: [GENERAL] unlooged tables

> -Original Message- > From: Sergey Konoplev [mailto:gray...@gmail.com] > Sent: Thursday, December 06, 2012 4:52 PM > To: Igor Neyman > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] unlooged tables > > Hi, > > On Thu, Dec 6, 2012 at 7:08 AM, Igor Neyman > wrote: > > Is there

Re: [GENERAL] Backend process is still runs even postmaster got killed

Hari Babu wrote: > Backend processes are still running even if the postmaster got killed and > all other server processes are exited by checking the > > Postmaster status. What server version? -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, T

Re: [GENERAL] Backend process is still runs even postmaster got killed

>On Fri, Dec 7, 2012 at 7:26 PM, Thalis Kalfigkopoulos wrote: >>On Fri, Dec 7, 2012 at 10:21 AM, Hari Babu < haribabu(dot)komm(at)huawei(dot)com> wrote: >>Backend processes are still running even if the postmaster got killed and all other server processes are e

Re: [GENERAL] Backend process is still runs even postmaster got killed

On Fri, Dec 7, 2012 at 10:21 AM, Hari Babu wrote: > Backend processes are still running even if the postmaster got killed and > all other server processes are exited by checking the > > Postmaster status. > > ** ** > > And the backend process is providing the service to the client. >

[GENERAL] Backend process is still runs even postmaster got killed

Backend processes are still running even if the postmaster got killed and all other server processes are exited by checking the Postmaster status. And the backend process is providing the service to the client. Is there any problems are possible? If we continue the system for a long time wi

Re: [GENERAL] Installing minimal client libraries on Windows

Albe Laurenz wrote: Mark Morgan Lloyd wrote: Apologies for this old chestnut, but I think it's a question more often asked than answered. If I want to install a minimal binary libpq.dll on a non-developer machine to support Lazarus/FPC programs, where do I get it? I definitely don't want to te

Re: [GENERAL] libpq - prevent automatic reconnect

Chris Angelico wrote: On Thu, Dec 6, 2012 at 5:56 AM, Tom Lane wrote: I suspect this action isn't dropping the TCP connection. It's only equivalent to a momentary glitch in your network connectivity --- and you'd be very unhappy if that caused TCP connections to go down, because networks have

Re: [GENERAL] Setting default privs for a user doesn't seem to work.

Dave Gauthier wrote: > What's wrong with this picture. Trying (failing) to create a user called > "select" with default select > privs and nothing else. Demo below. Comments in red... > > sde=# alter default privileges for user "select" grant select on tables to > "select"; > ALTER DEFAULT PRI