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 (s
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 JOIN
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, 邓尧 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 works perfe
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
>> “act
> 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 ne
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, th
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 wrote:
> Pankaj wrote:
>
> > now go to pg_
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 no
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
, coale
> 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
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
produc
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 fa
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
corrupt
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 certain
Hengky Liwandouw wrote:
> On Nov 24, 2013, at 11:21 PM, Kevin Grittner wrote:
>> Hengky Lie 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 faster ?
>>
>> Quite possibly -- that
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:
http://www.postgresql.o
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
o
On Mon, Nov 25, 2013 at 11:43 AM, John Kelly 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, status_d as
On Mon, Nov 25, 2013 at 11:57 AM, Scott Marlowe 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 query. I run the
> first or third queries, the ones that explicitly say that they're for
> <9.2
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; pgsql-general
>> 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 paus
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 wrote:
> On Mon, Nov 25, 2013 at 11:57 AM, Scott Marlowe
> 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 query. I run the
>> first or thi
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 foll
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
26 matches
Mail list logo
