Sorry for the delay, but I didn't have access to the database during the
weekend.
Here's the output of explain (analyze, buffers):
http://explain.depesz.com/s/scC
I'm also curious why it actually seems to touch the table assuming there are
output columns which I haven't defined anywhere
I apologise for the late response.
I've increased effective_cache_size to 50% and tried again - no change.
Afterwards, I've increased cpu_tuple_cost from 0.02 to 0.05 and tried again -
no change.
What is most curious to me is that I think the initial result set is very
small, so any JOINs
Hi,
I ran into a function does not exist error when invoking a function
created by myself. What's weird is that the function works perfectly if I
invoke it through the command line tool psql but fails if I invoke it
through the C API.
The SQL to create the function is:
CREATE OR REPLACE
My apologies, I connected to the wrong database in my C code ...
Sorry, if this E-mail bothers you.
On Mon, Nov 25, 2013 at 5:33 PM, 邓尧 tors...@gmail.com wrote:
Hi,
I ran into a function does not exist error when invoking a function
created by myself. What's weird is that the function
Thomas Kellerer wrote:
mrprice22 wrote on 22.11.2013 19:25:
We are in the process of moving from Oracle to PostgreSQL. We use a stored
procedure to populate some reporting tables once an hour. There are two
sets of these tables, set A and set B. We use synonyms to point to the
“active” set
Update - I have two hot replication slaves of this db, both have the problem.
I took one out of recovery and ran REINDEX table session_session and it
fixed the errors about this row. Now Im going to run vacuum and see if
there are other tables that complain, but Im guessing if so I will need
On Tue, Sep 10, 2013, Mahlon E. Smith wrote:
On Mon, Sep 09, 2013, Jeff Davis wrote:
You may have seen only partial information about that bug and the fix.
Yep, I totally glazed over the REINDEX. Giving it a go -- thank you!
As a followup for anyone else landing on this thread, the
Dera Kevin,
If you run checkpoint in database then you can delete the pg_xlog other
then current timestamp. We do this to our customer on regular basis when
pg_xlog exceed more then 15 gb
Regards
Pankaj
On Sat, Nov 23, 2013 at 1:48 AM, Kevin Grittner kgri...@ymail.com wrote:
Pankaj
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 path: C:\Program Files\PostgreSQL\9.3\share
But When I try to initiate a new Slony cluster in the PgAdmin interface, the
status-bar says Slony-I creation scripts not
Im having a problem changing several cursors in a function to use a passed
in child table name. Database is 8.4.3 on Linux
--Original cursor
c_runway18a cursor is
( select id, geom
, way_num as waydesignator, status_d as status
, t_width as width
, t_len as length
,
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
Thanks Shaun,
Im planning to schedule a time to do the vacuum freeze suggested
previously. So far the extent of the problem seems limited to the one
session table and the one session row that was being used by a heavy bot
scan at the time of the crash. Currently Im testing a recovery of a
TLDR: We want to be able to use streaming replication, WAL archiving, and
have the ability to restore from a backup made before a failover using the
WAL archive.
Setup:
We use postgresql 9.1 with streaming replication between a pair of nodes.
The nodes are identical, and can fail over and
Pankaj Mishra escribió:
Dera Kevin,
If you run checkpoint in database then you can delete the pg_xlog other
then current timestamp. We do this to our customer on regular basis when
pg_xlog exceed more then 15 gb
That is somewhat correct (meaning you are less likely to see data
corruption in
On Mon, Nov 25, 2013 at 03:00:56PM +0530, Pankaj Mishra wrote:
We do this to our customer on regular basis when
pg_xlog exceed more then 15 gb
Wow. Your poor customers. But I'm glad you phrased it do this to
our customer rather than do this _for_ our customer, since your
customer certainly is
Hengky Liwandouw hengkyliwand...@gmail.com wrote:
On Nov 24, 2013, at 11:21 PM, Kevin Grittner wrote:
Hengky Lie hengkyliwand...@gmail.com wrote:
this query takes long time to process. It takes around 48
seconds to calculate about 690 thousand record.
Is there any way to make calculation
Hi,
How is it possible to debug user defined functions written in C.
I can't just include all the files and run it.
Does anyone have an idea?
Janek Sendrowski
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
So I'm running 8.4 and go to this
page:http://wiki.postgresql.org/wiki/Lock_Monitoring
I have a query that is definitely blocked by another query. I run the
first or third queries, the ones that explicitly say that they're for
9.2 and neither produces any output. The third query gives me a list
On Mon, Nov 25, 2013 at 11:43 AM, John Kelly jtke...@gmail.com wrote:
Im having a problem changing several cursors in a function to use a passed
in child table name. Database is 8.4.3 on Linux
--Original cursor
c_runway18a cursor is
( select id, geom
, way_num as waydesignator,
On Mon, Nov 25, 2013 at 11:57 AM, Scott Marlowe scott.marl...@gmail.comwrote:
So I'm running 8.4 and go to this
page:http://wiki.postgresql.org/wiki/Lock_Monitoring
I have a query that is definitely blocked by another query. I run the
first or third queries, the ones that explicitly say that
Ah - that's what unpackaged meant. I read that page, but didn’t fully
understand what it was referring to. Thank you for your quick reply. :)
Josh
-Original Message-
From: Kevin Grittner [mailto:kgri...@ymail.com]
Sent: Friday, November 22, 2013 1:21 PM
To: Joshua Boyd;
Hi,
�
How is it possible to debug user defined functions written in C.
I can't just include all the files and run it.
�
Does anyone have an idea?
�
Janek Sendrowski
Hi,
I recall compiling with debug as normal, adding a printf followed by 30 sec
sleep, and
use the pause to attach gdb.
Hello,
I have a question regarding inserting a row into a child table when the PK of
the parent table is a composite key.
In this case, I have funding sources that buy projects, and projects generate
jobs. Project numbers are not universally unique, but are unique to funding
source. Therefore
On Mon, Nov 25, 2013 at 1:47 PM, Jeff Janes jeff.ja...@gmail.com wrote:
On Mon, Nov 25, 2013 at 11:57 AM, Scott Marlowe scott.marl...@gmail.com
wrote:
So I'm running 8.4 and go to this
page:http://wiki.postgresql.org/wiki/Lock_Monitoring
I have a query that is definitely blocked by another
Hi all,
We had a wraparound failure in the db and most of the tables and data were
missing. So we have done a full vacuum in db and after that the tables
reappeared but now the problem is, all the tables have duplicate when listing
tables with /dt. And also after the vacuum we recievied the
Nelson Green, 25.11.2013 23:01:
Hello,
When inserting a record into the jobs table that references projects by name,
do I have to query the projects table twice,
once to get the funding source number, and once to get the project sequence
number, even though both results will
return the
26 matches
Mail list logo