Re: [GENERAL] How to check streaming replication status

>From: Condor <con...@stz-bg.com> >To: Glyn Astill <glynast...@yahoo.co.uk> >Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>; >"pgsql-general-ow...@postgresql.org" <pgsql-general-ow...@postgresql.org> >Sent: Thursday,

Re: [GENERAL] How to check streaming replication status

> From: Condor > To: "pgsql-general@postgresql.org" > Sent: Thursday, 31 August 2017, 08:36:19 GMT+1 > > after a hour I get error message on slave server: > > LOG:  restored log file "0001008B00DC" from archive > LOG:  restored log

Re: [GENERAL] Invalid field size

>On Tuesday, 4 July 2017, 12:16:57 GMT+1, Moreno Andreo > wrote: > > > Any ideas? As for many error I got in the past I assume we are trying to > COPY FROM corrupted data (when using cheap pendrives we get often this > error). Should it be reasonable or I have to

Re: [GENERAL] Trigger based logging alternative to table_log

> From: Jeff Janes > To: "pgsql-general@postgresql.org" > Sent: Monday, 27 March 2017, 18:08 > Subject: [GENERAL] Trigger based logging alternative to table_log > > I have some code which uses table_log >

Re: [GENERAL] Table not cleaning up drom dead tuples

> We're, in general, pretty carefull with our DB, as it contains important > data. > Most rollback is issued by application (which processes all data inside > transactions). > > p.s. Time is in UTC (GMT+0) > > =# select min(xact_start) from pg_stat_activity where state<>'idle'; >

Re: [GENERAL] Table not cleaning up drom dead tuples

> This tables is original ones, it doesn't have any activity now. We copied > data to NEW tables and trying to solve root of the problem > > - target database where broken tables are located > > > - VACUUM FULL VERBOSE > =# VACUUM (FULL, VERBOSE) __orders_y2017_m2_to_drop; > INFO:

Re: [GENERAL] Table not cleaning up drom dead tuples

> > From: Антон Тарабрин > To: "pgsql-general@postgresql.org" > Sent: Tuesday, 14 March 2017, 14:05 > Subject: Re: [GENERAL] Table not cleaning up drom dead tuples > > > Yep. VACUUM FULL not helping us on OLD

Re: [GENERAL] Table not cleaning up drom dead tuples

> From: Антон Тарабрин > To: pgsql-general@postgresql.org > Sent: Tuesday, 14 March 2017, 12:09 > Subject: [GENERAL] Table not cleaning up drom dead tuples > General info about our database: > https://gist.github.com/aCLr/dec78ab031749e517550ac11f8233f70 > >

Re: [GENERAL] postgres driver for mysql

> From: Mimiko >To: Posthresql-general >Sent: Monday, 5 September 2016, 19:38 >Subject: [GENERAL] postgres driver for mysql > > >Hello to all. > >I want to move applications to postgres. But there are applications >which can use only mysql or

Re: [GENERAL] Transaction abort difference between psql, isql, ODBC and JDBC pgsql 8.4

From: Gary Cowell gary.cow...@gmail.com To: pgsql-general@postgresql.org Sent: Friday, 19 June 2015, 12:15 Subject: [GENERAL] Transaction abort difference between psql, isql, ODBC and JDBC pgsql 8.4 Hello I'm aware of the automatic transaction abort that occurs in PostgreSQL if you have

Re: [GENERAL] replacing jsonb field value

- Original Message - From: Andreas Kretschmer akretsch...@spamfence.net To: pgsql-general@postgresql.org Cc: Sent: Saturday, 30 May 2015, 13:10 Subject: Re: [GENERAL] replacing jsonb field value Michael Paquier michael.paqu...@gmail.com wrote: Append the new value to it

Re: [GENERAL] unexpected (to me) sorting order

From: Scott Marlowe scott.marl...@gmail.com To: Glyn Astill glynast...@yahoo.co.uk Cc: Björn Lundin b.f.lun...@gmail.com; pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Thursday, 9 April 2015, 13:23 Subject: Re: [GENERAL] unexpected (to me) sorting order On Wed

Re: [GENERAL] unexpected (to me) sorting order

From: Björn Lundin b.f.lun...@gmail.com To: pgsql-general@postgresql.org Sent: Wednesday, 8 April 2015, 10:09 Subject: [GENERAL] unexpected (to me) sorting order Hi! below are some commands to replicate a strange sorting order. I do not see why id:s 3-6 are in the middle of the result

Re: [GENERAL] unexpected (to me) sorting order

From: Chris Mair ch...@1006.org To: Björn Lundin b.f.lun...@gmail.com; pgsql-general@postgresql.org Cc: Sent: Wednesday, 8 April 2015, 10:36 Subject: Re: [GENERAL] unexpected (to me) sorting order select * from T_SORT order by NAME ; rollback; id |name

Re: [GENERAL] Reg: PL/pgSQL commit and rollback

From: Medhavi Mahansaria medhavi.mahansa...@tcs.com To: Adrian Klaver adrian.kla...@aklaver.com Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Tuesday, 17 March 2015, 14:30 Subject: Re: [GENERAL] Reg: PL/pgSQL commit and rollback Yes. I have read this document. But

Re: [GENERAL] Synchronous Replication Timeout

From: Teresa Bradbury t...@quintessencelabs.com To: pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Friday, 28 November 2014, 2:24 Subject: [GENERAL] Synchronous Replication Timeout Hi, I have a replication setup with a master and a single synchronous slave. If the slave

Re: [GENERAL] pgsql and asciidoc output

From: Bruce Momjian br...@momjian.us To: PostgreSQL-general pgsql-general@postgreSQL.org Sent: Tuesday, 11 February 2014, 22:56 Subject: [GENERAL] pgsql and asciidoc output Someone suggested that 'asciidoc' (http://en.wikipedia.org/wiki/AsciiDoc) would be a good output format for psql,

Re: [GENERAL] Better Connection Statistics

From: Shaun Thomas stho...@optionshouse.com To: 'bricklen' brick...@gmail.com Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Friday, 7 February 2014, 22:36 Subject: Re: [GENERAL] Better Connection Statistics I don't know any tools off-hand, but you might be able to

Re: [GENERAL] How to turn off DEBUG statements from psql commends

- Original Message - From: peterlen petera...@earthlink.net To: pgsql-general@postgresql.org Cc: Sent: Monday, 10 February 2014, 15:43 Subject: [GENERAL] How to turn off DEBUG statements from psql commends We are using PostgreSQL 9.3.  Something seems to have changed with our

Re: [GENERAL] unnest on multi-dimensional arrays

From: Pavel Stehule pavel.steh...@gmail.com To: bricklen brick...@gmail.com Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Thursday, 28 November 2013, 16:03 Subject: Re: [GENERAL] unnest on multi-dimensional arrays 2013/11/28 bricklen brick...@gmail.com On Wed, Nov 27,

Re: [GENERAL] Slony-I installation Help !

From: Tobadao tobaqu...@gmail.com To: pgsql-general@postgresql.org Cc: Sent: Monday, 25 November 2013, 16:40 Subject: [GENERAL] Slony-I installation Help ! Hi. I have downloaded postgresql-9.3.1-1-windows.exe and edb_slony_i_pg93.exe I'm using Windows XP v3. installation + set

Re: [GENERAL] How to find transaction ID

From: ascot.m...@gmail.com ascot.m...@gmail.com To: PostgreSQL general pgsql-general@postgresql.org Cc: ascot.m...@gmail.com Sent: Thursday, 8 August 2013, 14:52 Subject: [GENERAL] How to find transaction ID Hi, I am trying some restore tools,  can you advise how to find the latest

Re: [GENERAL] How to find transaction ID

From: Glyn Astill glynast...@yahoo.co.uk To: ascot.m...@gmail.com ascot.m...@gmail.com; PostgreSQL general pgsql-general@postgresql.org Cc: Sent: Thursday, 8 August 2013, 15:20 Subject: Re: [GENERAL] How to find transaction ID From: ascot.m...@gmail.com ascot.m...@gmail.com

Re: [GENERAL] Function tracking

From: Pavel Stehule pavel.steh...@gmail.com To: Rebecca Clarke r.clark...@gmail.com Cc: pgsql-general@postgresql.org Sent: Friday, 7 June 2013, 11:44 Subject: Re: [GENERAL] Function tracking Hello 2013/6/7 Rebecca Clarke r.clark...@gmail.com: Hi all I'm looking for suggestions

Re: [GENERAL] Function tracking

From: Rebecca Clarke r.clark...@gmail.com To: pgsql-general@postgresql.org Sent: Friday, 7 June 2013, 11:30 Subject: [GENERAL] Function tracking Hi all I'm looking for suggestions on the best way to track the updates to a function. We have two databases, Dev Live, so I want to update

[GENERAL] Newer kernels and CFS scheduler again

    Hi All, As I'll soon be looking at migrating some of our debian servers onto the new stable release, I've started doing a bit of basic pgbench testing. Initially I've seen a little performance regression with higher concurrent clients when going from the 2.6.32 kernel to 3.2.14 (select

Re: [GENERAL] Newer kernels and CFS scheduler again

From: Glyn Astill glynast...@yahoo.co.uk To: pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Tuesday, 30 April 2013, 16:58 Subject: [GENERAL] Newer kernels and CFS scheduler again Hi All, As I'll soon be looking at migrating some of our debian

Re: [GENERAL] Why does slony use a cursor? Anyone know?

From: Shaun Thomas stho...@optionshouse.com To: Glyn Astill glynast...@yahoo.co.uk Cc: PostgreSQL General pgsql-general@postgresql.org Sent: Wednesday, 6 March 2013, 14:35 Subject: Re: [GENERAL] Why does slony use a cursor? Anyone know? On 03/06/2013 04:49 AM, Glyn Astill wrote:   What

Re: [GENERAL] Why does slony use a cursor? Anyone know?

From: Shaun Thomas stho...@optionshouse.com To: PostgreSQL General pgsql-general@postgresql.org Cc: Sent: Tuesday, 5 March 2013, 14:51 Subject: [GENERAL] Why does slony use a cursor? Anyone know? Hey everyone, Frankly, I'm shocked at what I just found. We did a delete last night of

Re: [GENERAL] Recommendations on plpgsql debugger?

Hi Chris From: Chris Travers chris.trav...@gmail.com To: Postgres General pgsql-general@postgresql.org Sent: Tuesday, 15 January 2013, 7:59 Subject: [GENERAL] Recommendations on plpgsql debugger? Hi all; I have a client who needs a way to step through a PL/PGSQL function and ideally see

Re: [GENERAL] Vacuum analyze verbose output

From: Anjali Arora anjali_...@yahoo.co.in To: pgsql-general@postgresql.org Sent: Wednesday, 19 December 2012, 9:14 Subject: [GENERAL] Vacuum analyze verbose output Hi all, I ran following command on 8.2.2 postgresql:  psql -p port dbname -c vacuum analyze verbose last few lines from

Re: [GENERAL] Npgsql

An actual error message would be useful, but did you add a reference to the assembly in your project? From: Peter Kroon plakr...@gmail.com To: pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Friday, 23 November 2012, 18:13 Subject: [GENERAL]

[GENERAL] Type Name / Internal name returned by pg_catalog.format_type with/without prepended schema name?

Hi Guys, I was wondering if anyone could shed some light with type names returned by pg_catalog.format_type sometimes having the schema name prepended, and sometimes not? I'm calling it like format_type(pg_type.oid, NULL) . I'm using pg9.0, but I remember seeing this years ago on older

Re: [GENERAL] Type Name / Internal name returned by pg_catalog.format_type with/without prepended schema name?

From: Tom Lane t...@sss.pgh.pa.us To: Glyn Astill glynast...@yahoo.co.uk Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Wednesday, 27 June 2012, 14:31 Subject: Re: [GENERAL] Type Name / Internal name returned by pg_catalog.format_type

Re: [GENERAL] PostgreSQL DBA in SPAAAAAAAACE

__ From: Merlin Moncure mmonc...@gmail.com To: Joe Miller joe.d.mil...@gmail.com Cc: pgsql-general@postgresql.org Sent: Tuesday, 6 December 2011, 17:30 Subject: Re: [GENERAL] PostgreSQL DBA in SPCE On Tue, Dec 6, 2011 at 10:56 AM, Joe Miller

Re: [GENERAL] delete query taking way too long

What's the output of explain? --- On Thu, 12/8/10, Ivan Sergio Borgonovo m...@webthatworks.it wrote: From: Ivan Sergio Borgonovo m...@webthatworks.it Subject: [GENERAL] delete query taking way too long To: pgsql-general@postgresql.org Date: Thursday, 12 August, 2010, 12:14 I've delete from

Re: [GENERAL] pg_restore: [custom archiver] dumping a specific TOC data block out of order is not supported without ID on this input stream (fseek required)

Well I've ony just gotten round to taking another look at this, response inline below: --- On Fri, 30/4/10, Tom Lane t...@sss.pgh.pa.us wrote: Glyn Astill glynast...@yahoo.co.uk writes: The schema is fairly large, but I will try. My guess is that you can reproduce it with not a lot

Re: [GENERAL] pg_restore: [custom archiver] dumping a specific TOC data block out of order is not supported without ID on this input stream (fseek required)

--- On Fri, 21/5/10, Alban Hertroys dal...@solfertje.student.utwente.nl wrote: On 21 May 2010, at 11:58, Glyn Astill wrote: Well I've ony just gotten round to taking another look at this, response inline below: --- On Fri, 30/4/10, Tom Lane t...@sss.pgh.pa.us wrote: Glyn Astill

Re: [GENERAL] 8.3.7, 'cache lookup failed' for a table

Hi Grzegorz, Is it always the same OID(s)? Usually this means something somewhere has a link to an OID that has been removed. You could try digging through pg_catalog lookng for an oid column that refers to the OID in question. In my experience, when a slony 1.2.x slave is involved, this

Re: [GENERAL] 8.3.7, 'cache lookup failed' for a table

Did you not mention that this server was a slony slave at some point though? Just because you have removed slony, and the error comes from postgresql itself does not mean the corruption was not caused by misuse of slony. --- On Wed, 12/5/10, Grzegorz Jaśkiewicz gryz...@gmail.com wrote: From:

Re: [GENERAL] 8.3.7, 'cache lookup failed' for a table

--- On Wed, 12/5/10, Grzegorz Jaśkiewicz gryz...@gmail.com wrote: Glyn Astill glynast...@yahoo.co.uk wrote: Hi Grzegorz, Is it always the same OID(s)? Usually this means something somewhere has a link to an OID that has been removed. You could try digging through pg_catalog lookng

Re: [GENERAL] 8.3.7, 'cache lookup failed' for a table

--- On Wed, 12/5/10, Grzegorz Jaśkiewicz gryz...@gmail.com wrote: Alban Hertroys dal...@solfertje.student.utwente.nl wrote: On 12 May 2010, at 12:01, Glyn Astill wrote: Did you not mention that this server was a slony slave at some point though? Just because you have removed slony

[GENERAL] pg_restore: [custom archiver] dumping a specific TOC data block out of order is not supported without ID on this input stream (fseek required)

Hi chaps, I've just upgraded a server from 8.3 to 8.4, and when trying to use the parallel restore options I get the following error: pg_restore: [custom archiver] dumping a specific TOC data block out of order is not supported without ID on this input stream (fseek required) The dump I'm

Re: [GENERAL] pg_restore: [custom archiver] dumping a specific TOC data block out of order is not supported without ID on this input stream (fseek required)

--- On Fri, 30/4/10, Tom Lane t...@sss.pgh.pa.us wrote: Glyn Astill glynast...@yahoo.co.uk writes: I've just upgraded a server from 8.3 to 8.4, and when trying to use the parallel restore options I get the following error: pg_restore: [custom archiver] dumping a specific TOC data

Re: [GENERAL] pg_restore: [custom archiver] dumping a specific TOC data block out of order is not supported without ID on this input stream (fseek required)

--- On Fri, 30/4/10, Alvaro Herrera alvhe...@commandprompt.com wrote: Uh.  Why are you doing that?  pg_restore is supposed to restore the schema, then data, finally indexes and other stuff.  Are you using separate schema/data dumps?  If so, don't do that -- it's known to be slower. Yes,

[GENERAL] Wikipedia entry - AmigaOS port - error?

Hi Chaps, Just noticed on the wikipedia page under rdbms, it lists postgresql as available on AmigaOS. http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems Is this just an error, as I see edb advanced server is also listed as available, or was there some working

Re: [GENERAL] Wikipedia entry - AmigaOS port - error?

--- On Thu, 1/4/10, Tom Lane t...@sss.pgh.pa.us wrote: Just noticed on the wikipedia page under rdbms, it lists postgresql as available on AmigaOS. http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems Is this just an error, as I see edb advanced server is

Re: [GENERAL] Wikipedia entry - AmigaOS port - error?

--- On Thu, 1/4/10, Tom Lane t...@sss.pgh.pa.us wrote: But I do remember there was a set of libs called ixemul (http://aminet.net/package/dev/gg/ixemul-bin) that a lot of people used to port unix apps to the Amiga with, probably not enough to port postgres though. Ah, I wondered if there

Re: [GENERAL] when a table was last vacuumed

--- On Wed, 10/2/10, AI Rumman rumman...@gmail.com wrote: If it possible to find out when a table was last vacuumed? Try: select pg_stat_get_last_vacuum_time(oid) from pg_catalog.pg_class where relname = 'tablename'; select pg_stat_get_last_autovacuum_time(oid) from pg_catalog.pg_class

Re: [GENERAL] Server name in psql prompt

--- On Fri, 8/1/10, Mark Morgan Lloyd markMLl.pgsql- Is there any way of getting psql to display the name of the currently-connected server in its prompt, and perhaps a custom string identifying e.g. a disc set, without having to create a psqlrc file on every client system that's got a

[GENERAL] LDAP configuration changes in 8.4?

Hi Chaps, I'm setting up a new server on 8.4, and I'm struggling to get LDAP authentication working, even though I've got it working fine on 8.3. This is the format I'm using in 8.3: ldap ldap://notts.net.mycompany.com/My Company/Call Centre Users;CN=;,OU=Call Centre Users,OU=My

Re: [GENERAL] LDAP configuration changes in 8.4?

--- On Tue, 8/12/09, Magnus Hagander mag...@hagander.net wrote: ldapserver=notts.net.mycompany.com exclude the ldap:// part, and the base dn part. Excellent, that did the trick. Thanks. Glyn -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

[GENERAL] unexpected pageaddr

Hi Chaps, I'm doing my usual pull-the-plug tests on some new servers, and I'm seeing this in the logs during redo. Is this in any way normal? I'm guessing it is because it's just under LOG rather than something like WARNING, but I'm not taking any chances. I've got disk caches off, fsync on

Re: [GENERAL] unexpected pageaddr

--- On Tue, 1/12/09, Tom Lane t...@sss.pgh.pa.us wrote: I'm doing my usual pull-the-plug tests on some new servers, and I'm seeing this in the logs during redo. Is this in any way normal? Quite, this is one of the expected ways to detect end-of-WAL. Excellent, thanks Tom. --

Re: [GENERAL] Too easy to log in as the postgres user?

From: Thom Brown thombr...@gmail.com Subject: [GENERAL] Too easy to log in as the postgres user? To: PGSQL Mailing List pgsql-general@postgresql.org Date: Thursday, 15 October, 2009, 11:38 AM I've noticed that if I just log in to my server, I don't su to root, or become the postgres user, I

Re: [GENERAL] tar error while running basebackup

From: Andre Brandt bra...@decoit.de Subject: [GENERAL] tar error while running basebackup To: pgsql-general@postgresql.org Date: Tuesday, 13 October, 2009, 11:40 AM Hi! We're using two backup strategies to get consistent backups of our postgresql databases. First, we create a complete

Re: [GENERAL] Eclipse jdbc postgresql

--- On Tue, 1/9/09, Sheepjxx sheep...@gmail.com wrote: If I want to use postgres with jdbc , I have already download jdbc, do I need  extra option for compile postgres?--with-java?do I need change postgres.conf? No, you just need the postgres jdbc driver (jdbc.postgresql.org) in your

Re: [GENERAL]

From: sw...@opspl.com sw...@opspl.com Subject: Re: [GENERAL] To: pgsql-general@postgresql.org Date: Tuesday, 4 August, 2009, 11:03 AM Hello ,              You can use kill pid command to kill the slon daemons, find the pid's of the cluster and kill.      But that is

Re: [GENERAL] Replication

--- On Mon, 22/6/09, Gerry Reno gr...@verizon.net wrote: Have you ever tried any of the postgresql replication offerings? The only one that is remotely viable is slony and it is so quirky you may as well forget it. The rest are in some stage of decay/abandonment. There is no real

Re: [GENERAL] DB Migration 8.4 - 8.3

--- On Mon, 15/6/09, Eoghan Murray eoghanomur...@gmail.com wrote: From: Eoghan Murray eoghanomur...@gmail.com Subject: [GENERAL] DB Migration 8.4 - 8.3 To: pgsql-general@postgresql.org Date: Monday, 15 June, 2009, 10:19 PM I unintentionally installed 8.4beta2 on a server (using yum),

Re: [GENERAL] Could not open file pg_clog/....

--- On Tue, 12/5/09, Markus Wollny markus.wol...@computec.de wrote: From: Markus Wollny markus.wol...@computec.de Subject: [GENERAL] Could not open file pg_clog/ To: pgsql-general@postgresql.org Date: Tuesday, 12 May, 2009, 11:04 AM Hello! Recently one of my PostgreSQL servers has

Re: [GENERAL] Could not open file pg_clog/....

! -Ursprüngliche Nachricht- Von: Glyn Astill [mailto:glynast...@yahoo.co.uk] Gesendet: Dienstag, 12. Mai 2009 12:33 An: pgsql-general@postgresql.org; Markus Wollny The first thing I would have done if I've been forced to do that (if there was no other option?) would be a dump / restore

Re: [GENERAL] Could not open file pg_clog/....

--- On Tue, 12/5/09, Glyn Astill glynast...@yahoo.co.uk wrote: I'm going to duck out of this now though, and I think you should probably wait until someone a little more knowlegable replies. Also see here: http://archives.postgresql.org/pgsql-general/2006-07/msg01147.php -- Sent

[GENERAL] OLE DB

Hi Chaps, I was just wondering about the state of ole db connectivity for postgresql. From what I can see my options are; http://pgfoundry.org/projects/oledb/ Which doesn't seem to have been updated for 3 years - anyone using it? Or http://www.pgoledb.com/ Any others? -- Sent via

[GENERAL] Power outage and funny chars in the logs

Hi chaps, We had a power outage today when a couple of computer controlled power strips crashed (my secondary psu's will stay firmly in the wall sockets now though). I'd had a lot of fun pulling plugs out under load before we went into production so I wasn't particularly worried, and the

Re: [GENERAL] Upgrading from postgres 8.1 to 8.3

From: S Arvind arvindw...@gmail.com Subject: [GENERAL] Upgrading from postgres 8.1 to 8.3 To: pgsql-general@postgresql.org Date: Thursday, 7 May, 2009, 11:42 AM Our 600GB data was currently loaded in postgres 8.1 , we want to upgrade from postgres 8.1 to 8.3 . Can we able to point the data

Re: [GENERAL] Power outage and funny chars in the logs

From: Albe Laurenz laurenz.a...@wien.gv.at Subject: RE: [GENERAL] Power outage and funny chars in the logs To: glynast...@yahoo.co.uk, pgsql-general@postgresql.org Date: Thursday, 7 May, 2009, 2:44 PM Glyn Astill wrote: We had a power outage today when a couple of computer controlled

Re: [GENERAL] Power outage and funny chars in the logs

--- On Thu, 7/5/09, Massa, Harald Armin c...@ghum.de wrote: mentioning those @ symbols ... 1,5 weeks ago there was reported on this list the problem postgres service not starting on windows; after consulting event log the user reported as message bogus data in postmaster.pid.

[GENERAL] bizgres

Hi chaps, I'm looking at building an olap reporting environment and I came across this project on pgfoundry. However it was last updated over 3 years ago, am I correct in assuming that this probably isn't something I should be looking at? Can anyone point me at interesting tools they've used?

[GENERAL] Trigger function cost

Hi Chaps, Can anyone point me to docs for trigger function estimated cost? I see that when I create a volatile plpgsql trigger function it gets given a cost of 100 and a c function gets given a cost of 1. Is there any reason to mess with this? Thanks Glyn -- Sent via pgsql-general

Re: [GENERAL] Trigger function cost

From: Tom Lane t...@sss.pgh.pa.us Is there any reason to mess with this? No. The planner doesn't actually bother to figure the cost of triggers anyway, since presumably every correct plan will fire the same set of triggers. So even if you had a more accurate cost estimate than that

Re: [GENERAL] writing c functions for postgres

--- On Tue, 7/4/09, Albe Laurenz laurenz.a...@wien.gv.at wrote: I can find no VARATT_SIZEP in the PostgreSQL 8.3 headers. Where did you get that from? Yours, Laurenz Albe I think it's depreciated and he should be using SET_VARSIZE instead ... -- Sent via pgsql-general mailing

Re: [GENERAL] debugging in pgadmin

--- On Mon, 23/3/09, josep porres jmpor...@gmail.com wrote: A lot of time since the last debugging activity. I don't remember how to debug. I thought I had to set a breaking point in the function i want to debug, and then call that function. I'm doing this, and from another query window,

Re: [GENERAL] How to configure on a machine with a lot of memory?

Start by looking here http://www.postgresql.org/docs/8.3/static/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY And if you search the lists you'll find whole discussions on this topic that have been repeated over and over. Without generalising too much, for a dedicated machine you

Re: [GENERAL] Query palns and tug-of-war with enable_sort

--- On Thu, 19/2/09, Tom Lane t...@sss.pgh.pa.us wrote: Also, it'd be worth revisiting the question of whether you really still need enable_sort off ... personally, I'd think that reducing random_page_cost is a much saner way of nudging the planner in the direction of preferring

[GENERAL] Query palns and tug-of-war with enable_sort

Hi Chaps, We have a legacy application that used to have it's own sequential database backend, and to fetch data out of it's tables commands such as find gt table by index would be used. What we have now is a driver in the middle that constructs sql to access the data on pg8.3, typically of

Re: [GENERAL] Query palns and tug-of-war with enable_sort

Group (cost=0.00..11149194.48 rows=1 width=9) That's just bizarre. Can you put together a self-contained test case for this? Also, what version is it exactly? (8.3 is the wrong answer.) Thanks Tom, It's 8.3.5, and I get the same results on all my servers (3 replicated servers

Re: [GENERAL] Query palns and tug-of-war with enable_sort

No, those aren't the same plans. In particular what's bothering me is the lack of any sort in the first plan you showed (the one with HashAggregate at the top). That shouldn't be possible because of the ORDER BY --- a hash aggregate will deliver unsorted output so there should be a

[GENERAL] Diff tool for two schema

Anyone know of a decent diff tool for comparing two schemas? I Had a go with http://apgdiff.sourceforge.net/ but it appears it doesn't quote it's sql properly. A shame, otherwise it'd be just what I need. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

[GENERAL] Inheritance question

Hi chaps, I've got a question about inheritance here, and I think I may have gotten the wrong end of the stick as to how it works, or at least when to use it. What I intended to do was have a schema audit with an empty set of tables in it, then each quarter restore our audit data into schemas

Re: [GENERAL] Planner picking topsey turvey plan?

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 the

Re: [GENERAL] Planner picking topsey turvey plan?

Anyone? --- On Fri, 5/12/08, Glyn Astill [EMAIL PROTECTED] wrote: From: Glyn Astill [EMAIL PROTECTED] Subject: [GENERAL] Planner picking topsey turvey plan? To: pgsql-general@postgresql.org Date: Friday, 5 December, 2008, 2:23 PM Hi people, Does anyone know how I can change what I'm

Re: [ADMIN] [GENERAL] Planner picking topsey turvey plan?

explain analyze yourqueryhere say? On Sat, Dec 6, 2008 at 1:33 PM, Glyn Astill [EMAIL PROTECTED] wrote: Anyone? --- On Fri, 5/12/08, Glyn Astill [EMAIL PROTECTED] wrote: From: Glyn Astill [EMAIL PROTECTED] Subject: [GENERAL] Planner picking topsey turvey plan? To: pgsql-general

[GENERAL] Planner picking topsey turvey plan?

Hi people, Does anyone know how I can change what I'm doing to get pgsql to pick a better plan? I'll explain what I've done below but please forgive me if I interpret the plans wrong as I try to describe, I've split it into 4 points to try and ease the mess of pasting in the plans.. 1) I've

Re: [GENERAL] IDLE in transaction - safest way to kill

select pg_cancel_backend(pid); --- On Fri, 5/12/08, William Temperley [EMAIL PROTECTED] wrote: From: William Temperley [EMAIL PROTECTED] Subject: [GENERAL] IDLE in transaction - safest way to kill To: pgsql-general@postgresql.org Date: Friday, 5 December, 2008, 2:08 PM Hi all Could

Re: [GENERAL] 8.3 libpq.dll not working on some versions of windows

--- On Sat, 15/11/08, Tony Caduto [EMAIL PROTECTED] wrote: Hi, We have been running into issues where the 8.3.x versions of libpq.dll will not load in certain versions of windows and WINE(does not load at all on wine). It seems to be hit and miss on Windows XP, mostly seems to affect SP3

Re: [GENERAL] [Slony1-general] ERROR: incompatible library

--- On Wed, 12/11/08, Tony Fernandez [EMAIL PROTECTED] wrote: Date: Wednesday, 12 November, 2008, 10:52 PM Hello lists, I am trying to run Slony on a Master Postgres 8.1.11 replicating to a Slave same version and 2nd Slave Postgres 8.3.4. I am getting the following error:

[GENERAL] bytea field, a c function and pgcrypto driving me mad

Hi chaps, I think I'm going to struggle to describe this, but hopefully someone can squint and see where I'm going wrong. I've got a c function called ftest, all it does is take some text and prepend abcdefghijklmnopqr onto it. I use it to pass a key into pgp_sym_encrypt/decrypt working on a

Re: [GENERAL] bytea field, a c function and pgcrypto driving me mad

ISTM that in this line: keying = (text *)palloc( keylen + unamelen ); You forgot to include the length of the header VARHDRSZ. Aha, that'd be it, it's been a long day. Thanks Martijn -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] Autovacuum and relfrozenxid

Hi chaps, I've noticed age(relfrozenxid) of some of our tables approaching vacuum_freeze_min_age, am I right in thinking this is nothing to worry about, autovacuum will just get invoked for those tables? Even if it isn't, should I be tuning autovacuum so that those tables should have been

Re: [GENERAL] Autovacuum and relfrozenxid

If there's no update activity on that table, this is to be expected. Hmm, there is activity on the table, so I'm guessing I've not got autovacuumm tuned aggressively enough. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Tips on how to efficiently debugging PL/PGSQL

From: [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: [GENERAL] Tips on how to efficiently debugging PL/PGSQL To: pgsql-general@postgresql.org Date: Thursday, 23 October, 2008, 6:19 PM Just to seek some tips on how to efficiently debug PL/SQL. One thing that bugs me in particular is the

[GENERAL] Using a variable as tablename ins plpgsql?

Hi people, Hopefully this is a quickie, I want to pass in a table name to a plpgsql function and then use that table name in my queries. Is EXECUTE the only way to do this? Ta Glyn Send instant messages to your online friends http://uk.messenger.yahoo.com -- Sent via pgsql-general

Re: [GENERAL] PQescapestringConn not found in libpq.dll

It sounds like what you're actually using is an 8.1 or older libpq.dll. Sorry to steer this off the topic a bit, but we have a 3rd party app that insists on using libpq.dll version 8.0.1.5031 and we're on pgsql v 8.3.4. Apart from lacking functionality, is there anything else I should be

Re: [GENERAL] PQescapestringConn not found in libpq.dll

Apart from lacking functionality, is there anything else I should be aware of i.e. could this cause us any serious problems? You really need to have a word with that application vendor. Thanks Tom, I will do. Send instant messages to your online friends http://uk.messenger.yahoo.com

[GENERAL] WARNING: 25P01: there is no transaction in progress

Hi Chaps, I'm getting the aforementioned warning in my logs from a closed source piece of software. The software helps us convert over some old proprietary data files, and it's basically just done a COPY into a newly created table, after the warning it then goes on to create some indexes. I

Re: [GENERAL] WARNING: 25P01: there is no transaction in progress

not misread that? Ta Glyn --- On Wed, 1/10/08, Glyn Astill [EMAIL PROTECTED] wrote: From: Glyn Astill [EMAIL PROTECTED] Subject: [GENERAL] WARNING: 25P01: there is no transaction in progress To: pgsql-general@postgresql.org Date: Wednesday, 1 October, 2008, 5:23 PM Hi Chaps, I'm getting

Re: [GENERAL] WARNING: 25P01: there is no transaction in progress

I presume it's issuing some sort of commit or rollback without a begin, however the programs authors are telling me that's not the case and their software is not at fault. Of course their software can't be at fault, as it is entirely bug free ;-) You could turn on statement logging in

Re: [GENERAL] WARNING: 25P01: there is no transaction in progress

If you're using connection pooling it's possible that the a connection is getting reused and a commit is happening there. It's not an uncommon practice to do a rollback when first getting a shared connection to make sure it's fresh and clean... That's interesting to hear. Although we

Re: [GENERAL] WARNING: 25P01: there is no transaction in progress

Ah, It just hit me that I probably logged all the wrong type of stuff there. I should have been logging statements shouldn't I? http://privatepaste.com/6f1LYISojo I think this shows up that they're sending an extra commit transaction on line 36. Could someone do us a

  1   2   3   >