>From: Condor
>To: Glyn Astill
>Cc: "pgsql-general@postgresql.org" ;
>"pgsql-general-ow...@postgresql.org"
>Sent: Thursday, 31 August 2017, 09:42:17 GMT+1
>Subject: Re: [GENERAL] How to check streaming replication status
>>> My question is:
> 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 file "0001008B00DD" from archive
> cp: c
>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 search elsewhere?
I'd start by
> 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
> (http://pgfoundry.org/projects/tablelog/) to keep a log of changes to
> selected tables.
> 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';
>
> 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: vacuu
>
> 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 table, that are not getting updated
> and not used
> 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
>
> Information about problematic t
> 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 local mdb or mssql. For now I run a mysql
>server
> From: Gary Cowell
>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 DML throw
- Original Message -
> From: Andreas Kretschmer
> To: pgsql-general@postgresql.org
> Cc:
> Sent: Saturday, 30 May 2015, 13:10
> Subject: Re: [GENERAL] replacing jsonb field value
>
> Michael Paquier wrote:
>
>>
>> Append the new value to it the existing field, jsonb has as proper
> From: Scott Marlowe
> To: Glyn Astill
> Cc: Björn Lundin ; "pgsql-general@postgresql.org"
>
> Sent: Thursday, 9 April 2015, 13:23
> Subject: Re: [GENERAL] unexpected (to me) sorting order
>
> On Wed, Apr 8, 2015 at 3:33 AM, Glyn Astill
> wrote:
> From: Chris Mair
> To: Björn Lundin ; 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
>> +
>>1
> From: Björn Lundin
>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 set.
>
>What
> From: Medhavi Mahansaria
>To: Adrian Klaver
>Cc: "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 my issue is that even when it throws
and exception I need to rollbac
> From: Teresa Bradbury
>To: "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 dies (or the network goes down) I would lik
> From: Bruce Momjian
> To: PostgreSQL-general
> 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, similar to the existing output formats
- Original Message -
> From: peterlen
> 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 psql
> command-li
> From: Shaun Thomas
>To: 'bricklen'
>Cc: "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 generate
>> partial statistics from the log files with a descr
> From: Pavel Stehule
>To: bricklen
>Cc: "pgsql-general@postgresql.org"
>Sent: Thursday, 28 November 2013, 16:03
>Subject: Re: [GENERAL] unnest on multi-dimensional arrays
>
>2013/11/28 bricklen
>
>On Wed, Nov 27, 2013 at 11:28 PM, Pavel Stehule
>wrote:
>>
>>Hello
>>>
>>>
>>>postgres=# CR
> From: Tobadao
> 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 Slony-I pa
> From: Glyn Astill
> To: "ascot.m...@gmail.com" ; PostgreSQL general
>
> Cc:
> Sent: Thursday, 8 August 2013, 15:20
> Subject: Re: [GENERAL] How to find transaction ID
>
>
>
>> From: "ascot.m...@gmail.com"
>> To: PostgreSQL
> From: "ascot.m...@gmail.com"
> To: PostgreSQL general
> 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
> transaction ID in PostgreSQL and the
> From: Rebecca Clarke
>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 Live w
> From: Pavel Stehule
> To: Rebecca Clarke
> Cc: pgsql-general@postgresql.org
> Sent: Friday, 7 June 2013, 11:44
> Subject: Re: [GENERAL] Function tracking
>
> Hello
>
> 2013/6/7 Rebecca Clarke :
>> Hi all
>>
>> I'm looking for suggestions on the best way to track the updates to a
>> func
>
> From: Glyn Astill
>To: "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
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 on
> From: Shaun Thomas
> To: Glyn Astill
> Cc: PostgreSQL General
> 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 version of slony are you on? The
> From: Shaun Thomas To: PostgreSQL General
> 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 a few million rows, and come back this morni
Hi Chris
> From: Chris Travers
>To: Postgres General
>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 what one is doing at present. I noticed
> From: Anjali Arora
>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 "vacuum
An actual error message would be useful, but did you add a reference to the
assembly in your project?
>
> From: Peter Kroon
>To: "pgsql-general@postgresql.org"
>Sent: Friday, 23 November 2012, 18:13
>Subject: [GENERAL] Npgsql
>
>
>I've installed Npgsql via
>
> From: Tom Lane
>To: Glyn Astill
>Cc: "pgsql-general@postgresql.org"
>Sent: Wednesday, 27 June 2012, 14:31
>Subject: Re: [GENERAL] Type Name / Internal name returned by
>pg_catalog.format_type with/without prepended schem
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 version
__
> From: Merlin Moncure
>To: Joe Miller
>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 wrote:
>> You may have seen this, but RedGate s
What's the output of explain?
--- On Thu, 12/8/10, Ivan Sergio Borgonovo wrote:
> From: Ivan Sergio Borgonovo
> Subject: [GENERAL] delete query taking way too long
> To: pgsql-general@postgresql.org
> Date: Thursday, 12 August, 2010, 12:14
> I've
> delete from catalog_items where ItemID in (sel
--- On Fri, 21/5/10, Alban Hertroys 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
> wrote:
> >
> &
Well I've ony just gotten round to taking another look at this, response inline
below:
--- On Fri, 30/4/10, Tom Lane wrote:
> Glyn Astill
> writes:
> > The schema is fairly large, but I will try.
>
> My guess is that you can reproduce it with not a lot of
> data
--- On Wed, 12/5/10, Grzegorz Jaśkiewicz wrote:
> Alban Hertroys
>
> 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
--- On Wed, 12/5/10, Grzegorz Jaśkiewicz wrote:
> Glyn Astill
> 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 di
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 wrote:
> From: Grzegorz Jaśkiewi
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 usua
--- On Fri, 30/4/10, Alvaro Herrera 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, I'm restoring the s
--- On Fri, 30/4/10, Tom Lane wrote:
> Glyn Astill
> 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
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 tr
--- On Thu, 1/4/10, Tom Lane 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 might not be
--- On Thu, 1/4/10, Tom Lane 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
> also list
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 co
--- On Wed, 10/2/10, AI Rumman 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 where
relname = '
--- On Fri, 8/1/10, Mark Morgan Lloyd 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 precompiled psql i
--- On Tue, 8/12/09, Magnus Hagander 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 your subscripti
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 Company,DC=no
--- On Tue, 1/12/09, Tom Lane 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.
--
Sent via
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 o
> From: Thom Brown
> Subject: [GENERAL] Too easy to log in as the "postgres" user?
> To: "PGSQL Mailing List"
> 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 can get straight into the
> database
> From: Andre Brandt
> 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
> dump every
--- On Tue, 1/9/09, Sheepjxx 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
classpath.
Glyn
> From: sw...@opspl.com
> Subject: Re: [GENERAL]
> To: pgsql-general@postgresql.org
> Date: Tuesday, 4 August, 2009, 11:03 AM
>
> Hello ,
>
> >>
> >
> You can use "kill " command to
> kill the slon daemons,
> > find
> > the pid's of the cluster and kill.
> >
> >
>
> But tha
--- On Mon, 22/6/09, Gerry Reno 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
> replication available f
--- On Mon, 15/6/09, Eoghan Murray wrote:
> From: Eoghan Murray
> 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), while I
> run 8.3.7 on my dev machine.
> Th
--- On Tue, 12/5/09, Glyn Astill 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
--- On Tue, 12/5/09, Markus Wollny wrote:
> From: Markus Wollny
> Subject: AW: [GENERAL] Could not open file "pg_clog/"
> To: glynast...@yahoo.co.uk, pgsql-general@postgresql.org
> Date: Tuesday, 12 May, 2009, 11:52 AM
> Hi!
>
> > -Ursprüngliche N
--- On Tue, 12/5/09, Markus Wollny wrote:
> From: Markus Wollny
> 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 started throwing
> error
> messages like the
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 pgsq
--- On Thu, 7/5/09, Massa, Harald Armin 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". Aft
> From: Albe Laurenz
> 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
>
>
> From: S Arvind
> 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
> directly or
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 datab
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?
> From: Tom Lane
>
> > 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
> one,
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 mailin
--- On Tue, 7/4/09, Albe Laurenz 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 list (pgsql-general@
--- On Mon, 23/3/09, josep porres 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, i call
> the
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
--- On Thu, 19/2/09, Tom Lane 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 indexscans.
>
We h
>
> 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
> shoul
> > 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
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
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
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 change
> 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
l-general@postgresql.org, [EMAIL PROTECTED]
> Date: Saturday, 6 December, 2008, 8:35 PM
> what does explain analyze yourqueryhere say?
>
> On Sat, Dec 6, 2008 at 1:33 PM, Glyn Astill
> <[EMAIL PROTECTED]> wrote:
> > Anyone?
> >
> >
> > --- On Fri, 5/
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,
>
>
select pg_cancel_backend();
--- On Fri, 5/12/08, William Temperley <[EMAIL PROTECTED]> wrote:
> From: William Temperley <[EMAIL PROTECTED]>
> Subject: [GENERAL] in transaction - safest way to kill
> To: pgsql-general@postgresql.org
> Date: Friday, 5 December, 2008, 2:08 PM
> Hi all
>
> Could
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
--- 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
> affe
--- 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 err
> 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
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
>
> 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:
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 vacu
> 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 t
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 mail
> > 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.yah
> 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 a
> > 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
>
> 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.
Alth
> > 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 l
k I've 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 Octo
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 p
1 - 100 of 205 matches
Mail list logo
