Re: [GENERAL] Primary key vs unique index

On Fri, Mar 18, 2011 at 6:38 AM, Voils, Steven M wrote: > What are the general guidelines under which autovacuum will trigger?  I was > unaware it was turned on by default for the newer versions.  Would it be > worthwhile to leave the manual vacuuming on?  Currently it runs immediately > after

Re: [GENERAL] Primary key vs unique index

On Fri, Mar 18, 2011 at 8:38 AM, Voils, Steven M wrote: > What are the general guidelines under which autovacuum will trigger? I was > unaware it was turned on by default for the newer versions. Would it be > worthwhile to leave the manual vacuuming on? Currently it runs immediately > after lar

Re: [GENERAL] postgres conferences missing videos?

On Mon, Mar 21, 2011 at 7:16 PM, John R Pierce wrote: > On 03/21/11 5:04 PM, Tomas Vondra wrote: >> >> So just put there a tripod, a reasonable HD cam for $300 and you'll get >> a decent video of the session. >> > > you definitely want a sound patch from a lapel mic or the room PA, and not > be us

Re: [GENERAL] postgres conferences missing videos?

On 03/21/11 5:04 PM, Tomas Vondra wrote: So just put there a tripod, a reasonable HD cam for $300 and you'll get a decent video of the session. you definitely want a sound patch from a lapel mic or the room PA, and not be using on-camera sound. and probably two cameras, one aimed at the pre

Re: [GENERAL] postgres conferences missing videos?

Dne 22.3.2011 00:20, David Fetter napsal(a): > On Mon, Mar 21, 2011 at 11:55:20PM +0100, Aljoša Mohorović wrote: >> On Mon, Mar 21, 2011 at 9:45 PM, David Fetter wrote: >>> Who proposes, volunteers! How are you going to help? >> >> being on a different continent and unable to attend doesn't actua

[GENERAL] Backups with continuous archiving

Using Postgres 9.0.3 on Solaris 10 (Sparc). I have a few questions concerning hot backups with continuous archiving. We have read and think we understand the Postgres documentation on backup and restore located here: http://www.postgresql.org/docs/9.0/static/continuous-archiving.html We

Re: [GENERAL] postgres conferences missing videos?

Dne 21.3.2011 21:45, David Fetter napsal(a): > Who proposes, volunteers! How are you going to help? Well, if this is the only problem then I happily volunteer to take care of this for pgday 2011. regards Tomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make change

Re: [GENERAL] postgres conferences missing videos?

Dne 21.3.2011 20:23, Vick Khera napsal(a): > On Mon, Mar 21, 2011 at 1:45 PM, Aljoša Mohorović > wrote: >> postgres is losing a lot of promotional and educational materials, why >> is this happening? >> > > Someone has to do lots of work to tape the talks, get proper > permissions from the presen

Re: [GENERAL] postgres conferences missing videos?

On Tue, Mar 22, 2011 at 12:20 AM, David Fetter wrote: > Not so, by a long shot.  If this is actually important to you, there > are plenty of ways you could help, not least by funding the effort. [...] > What you really, really need to stop doing is proposing that others do > an enormous amount of

Re: [GENERAL] postgres conferences missing videos?

On Mon, Mar 21, 2011 at 11:55:20PM +0100, Aljoša Mohorović wrote: > On Mon, Mar 21, 2011 at 9:45 PM, David Fetter wrote: > > Who proposes, volunteers!  How are you going to help? > > being on a different continent and unable to attend doesn't actually > enable me to do something. Not so, by a lo

Re: [GENERAL] query taking much longer since Postgres 8.4 upgrade

Try this : 1) rewrite your query as is : select course_id AS EXTERNAL_COURSE_KEY, user_id AS EXTERNAL_PERSON_KEY, 'Student' AS ROLE, 'Y' AS AVAILABLE_IND from course_user_link AS CUL INNER JOIN course_control AS CC ON CUL.course_id = CC.course_id where

Re: [GENERAL] postgres conferences missing videos?

On Mon, Mar 21, 2011 at 9:45 PM, David Fetter wrote: > Who proposes, volunteers!  How are you going to help? being on a different continent and unable to attend doesn't actually enable me to do something. my post doesn't try to undermine actual work being done by people on conferences. i'm just t

Re: [GENERAL] postgresql install problem

On 22 March 2011 08:54, Alex wrote: > It seems that I don't get the postgresql server installed or available for > me to run in admin tools then services. postgresql is not listed as a > service available to start or stop! > > Why do I not get the service installed and running? What OS? Which pos

Re: [GENERAL] Passing a table as parameter

2011/3/21 Vibhor Kumar : > > On Mar 22, 2011, at 1:52 AM, Pavel Stehule wrote: > >> simply thinks as using USAGE clause or functions quote_ident, >> quote_literal are faster and absolutly secure :). Software like SQL > > I don't think usage of quote_ident in current requirement of user, would > pr

Re: [GENERAL] Passing a table as parameter

On Mar 22, 2011, at 1:52 AM, Pavel Stehule wrote: > simply thinks as using USAGE clause or functions quote_ident, > quote_literal are faster and absolutly secure :). Software like SQL I don't think usage of quote_ident in current requirement of user, would prevent sql injection. Running sql mul

Re: [GENERAL] postgres conferences missing videos?

On Mon, Mar 21, 2011 at 09:09:35PM +0100, Aljoša Mohorović wrote: > On Mon, Mar 21, 2011 at 8:23 PM, Vick Khera wrote: > > Someone has to do lots of work to tape the talks, get proper > > permissions from the presenters, and then host the videos.  Often this > > would land on the shoulders of the

Re: [GENERAL] query execution time

On Mar 21, 2011, at 12:03 PM, preetika tyagi wrote: > I tried running the same query after reboot and back-to-back, it was taking > less time in both the cases. It means the problem is something else. > > Can there be a reason which is more hardware/operating system specific and > due to which

Re: [GENERAL] Passing a table as parameter

2011/3/21 Vibhor Kumar : > > On Mar 22, 2011, at 1:32 AM, Pavel Stehule wrote: > >> it can work too, but there is sql injection risk. >> >> Do newer 'SELECT ... FROM ' || tabname || ' ... >> >> Regards >> >> Pavel Stehule > > Yes true. Same with the following too: > CREATE FUNCTION foo(tablename te

Re: [GENERAL] query taking much longer since Postgres 8.4 upgrade

Incredible! Setting enable_nestloop off temporarily for the run of this script made it run in less than a minute (had been running in 10 or 11 minutes). I think you have found a solution for many of my slow running scripts that use these same type of joins. Thanks again. Julie >>-Origin

[GENERAL] postgresql install problem

It seems that I don't get the postgresql server installed or available for me to run in admin tools then services. postgresql is not listed as a service available to start or stop! Why do I not get the service installed and running? -- Sent via pgsql-general mailing list (pgsql-general@postgre

Re: [GENERAL] Passing a table as parameter

On Mar 22, 2011, at 1:32 AM, Pavel Stehule wrote: > it can work too, but there is sql injection risk. > > Do newer 'SELECT ... FROM ' || tabname || ' ... > > Regards > > Pavel Stehule Yes true. Same with the following too: CREATE FUNCTION foo(tablename text) RETURNS SETOF text AS $$ BEGIN RET

Re: [GENERAL] postgres conferences missing videos?

On Mon, Mar 21, 2011 at 8:23 PM, Vick Khera wrote: > Someone has to do lots of work to tape the talks, get proper > permissions from the presenters, and then host the videos.  Often this > would land on the shoulders of the conference organizers, who are > already working hard just to pull off the

Re: [GENERAL] Passing a table as parameter

2011/3/21 Vibhor Kumar : > > On Mar 21, 2011, at 11:13 PM, Jon Smark wrote: > >> >> Is there any way for a SQL or PL/pgSQL function to receive a table >> as parameter?  As an illustration, consider the dummy example below. >> Note that functions get_from_data1 and get_from_data2 follow essentially

Re: [GENERAL] Passing a table as parameter

On Mar 21, 2011, at 11:13 PM, Jon Smark wrote: > > Is there any way for a SQL or PL/pgSQL function to receive a table > as parameter? As an illustration, consider the dummy example below. > Note that functions get_from_data1 and get_from_data2 follow essentially > the same pattern; it would

Re: [GENERAL] postgres conferences missing videos?

On Mon, Mar 21, 2011 at 1:45 PM, Aljoša Mohorović wrote: > postgres is losing a lot of promotional and educational materials, why > is this happening? > Someone has to do lots of work to tape the talks, get proper permissions from the presenters, and then host the videos. Often this would land o

Re: [GENERAL] Passing a table as parameter

Hello 2011/3/21 Jon Smark : > Hi, > > Is there any way for a SQL or PL/pgSQL function to receive a table > as parameter?  As an illustration, consider the dummy example below. > Note that functions get_from_data1 and get_from_data2 follow essentially > the same pattern; it would be nice to define

Re: [GENERAL] Fw: slony- No index found

On Mon, Mar 21, 2011 at 10:30 AM, Vick Khera wrote: > > The schemas in the two database must be *identical*.  there are specific > things you can let be different, but if you are just starting out, don't try > to do that. also, there is a slony mailing list where the experts hang out. Not entir

Re: [GENERAL] query execution time

Thank you, Scott! I tried running the same query after reboot and back-to-back, it was taking less time in both the cases. It means the problem is something else. Can there be a reason which is more hardware/operating system specific and due to which the behavior is not uniform? Preetika On Mon,

[GENERAL] postgres conferences missing videos?

am i the only one thinking that postgres is seriously lacking recordings from conferences? when i look at talks schedule from some postgres conference i always wonder why nobody records talks? i've heard arguments before, for other projects/conferences, that authors/companies don't allow recording

[GENERAL] Passing a table as parameter

Hi, Is there any way for a SQL or PL/pgSQL function to receive a table as parameter? As an illustration, consider the dummy example below. Note that functions get_from_data1 and get_from_data2 follow essentially the same pattern; it would be nice to define instead a single polymorphic function

Re: [GENERAL] query taking much longer since Postgres 8.4 upgrade

> On Mon, Mar 21, 2011 at 11:32 AM, wrote: >>> Incredible!  Setting enable_nestloop off temporarily for the run of >>> this >>> script made it run in less than a minute (had been running in 10 or 11 >>> minutes).  I think you have found a solution for many of my slow >>> running >>> scripts that

Re: [GENERAL] Doubt in Backup

> Dear all, > > 2 days ago, I need to backup 2 databases in my Database server because I need > to format the system and reinstalls again with the back up databases. > > After a fresh install of ubuntu-10.4 , I install postgreplus-8.4 binary and I > think giving the previous data directory /hd

Re: [GENERAL] query taking much longer since Postgres 8.4 upgrade

On Mon, Mar 21, 2011 at 11:32 AM, wrote: >> Incredible!  Setting enable_nestloop off temporarily for the run of this >> script made it run in less than a minute (had been running in 10 or 11 >> minutes).  I think you have found a solution for many of my slow running >> scripts that use these same

Re: [GENERAL] Fw: slony- No index found

The schemas in the two database must be *identical*. there are specific things you can let be different, but if you are just starting out, don't try to do that. also, there is a slony mailing list where the experts hang out. On Mon, Mar 21, 2011 at 5:33 AM, basobdutta kar wrote: > > > --- On *M

Re: [GENERAL] query taking much longer since Postgres 8.4 upgrade

> Incredible! Setting enable_nestloop off temporarily for the run of this > script made it run in less than a minute (had been running in 10 or 11 > minutes). I think you have found a solution for many of my slow running > scripts that use these same type of joins. Thanks again. > Julie Nice. C

Re: [GENERAL] query execution time

On Mar 21, 2011, at 9:55 AM, preetika tyagi wrote: > For example, if A is 15 minutes, then B is 1.5 hrs. Well, considering that random disk access is on the order of 10,000 times slower than RAM... But you can answer the question yourself by comparing the query run against cold caches (after

Re: [GENERAL] query execution time

Thank you, Vibhor! I am wondering if caching will make such a big difference. For example, if A is 15 minutes, then B is 1.5 hrs. What could be other factors in case database server is separated from clients (on different computer systems)? Preetika On Mon, Mar 21, 2011 at 2:48 AM, Vibhor Kumar

Re: [GENERAL] Doubt in Backup

On Sunday, March 20, 2011 11:13:57 pm Adarsh Sharma wrote: > Dear all, > > 2 days ago, I need to backup 2 databases in my Database server because I > need to format the system and reinstalls again with the back up databases. > > After a fresh install of ubuntu-10.4 , I install postgreplus-8.4 bin

[GENERAL] Fw: slony- No index found

--- On Mon, 3/21/11, basobdutta kar wrote: From: basobdutta kar Subject: slony- No index found To: pgsqlgene...@postgresql.org Date: Monday, March 21, 2011, 3:01 PM Sir/Madam, I have two databases- db1  and db2 db1 is the master  and db2 is slave. In db1,  create table t1(id integer  p

[GENERAL] Fw: slony- No index found

--- On Mon, 3/21/11, basobdutta kar wrote: From: basobdutta kar Subject: Fw: slony- No index found To: pgsql-general@postgresql.org Date: Monday, March 21, 2011, 3:02 PM --- On Mon, 3/21/11, basobdutta kar wrote: From: basobdutta kar Subject: slony- No index found To: pgsqlgene...@postgr

[GENERAL] Disconnect/Resource releasing/PING

Hi! Many databases (like Firebird) have some time limitation for the clients. These cases possible with client: a.) It is working, but network connection is temp. down. b.) The client is crashing c.) The client is on, but it is not working for N minutes. When the server experience that client is

[GENERAL] Linux, Hungarian charset (Win1250) is supports the hungarian collation?

Dear Everybody! We need to choice a DB for our new project. Two of the databases are possible to choose. 1.) PGSQL 9.x 2.) FireBird 2.x We needs to serve 75/80 users in a time. The client platform is Windows, Delphi based applications with [Zeos/PGDAC] or [IBX/ZEOS]. The server is may Windows,

Re: [GENERAL] query execution time

On Mar 21, 2011, at 10:42 AM, preetika tyagi wrote: > Query: INSERT INTO table1 SELECT * FROM table2. > Execution Time: A ms. > > Query: INSERT INTO table1 SELECT * FROM table2. > Execution Time: B ms If session is same, then B < A if the data is cached due to execution of first statement. B >

Re: [GENERAL] Doubt in Backup

On Mar 21, 2011, at 11:43 AM, Adarsh Sharma wrote: > > But what I have noticed that there is 6 databases in my Postgres database and > one database pdc_uima doesn't have any entry in \l command. > > However I restore it from my previous backup. That should not happen. If the Binaries version

Re: [GENERAL] Doubt in Backup

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, Mar 21, 2011 at 11:43:57AM +0530, Adarsh Sharma wrote: > Dear all, > > 2 days ago, I need to backup 2 databases in my Database server because I > need to format the system and reinstalls again with the back up databases. > > After a fresh inst

Re: [GENERAL] cannot connect to server

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Srikanth, hae a look at this thread: Most probably the cause on your computer is different, but you can get some ideas about where to find log files and how