Hi,
On Wed, 2013-02-13 at 12:03 +0900, Jeffrey Jones wrote:
> As I can tell the PostgreSQL 9.2 yum repository for use with RHEL6
> (64bit) is broken.
>
> On a fresh RHEL6.3 (64-bit) installation, as root, run the following
> commands:
>
> rpm -i
> http://yum.postgresql.org/9.2/redhat/rhel-6
Hello Devrim
I have run the commands as you specified but unfortunately the error
pops up again when I run yum makecache.
I have tried this on two separately built VMs, the exact details are:
RHEL 6.3 (64 bit)
Registered with RedHat using subscription-manager
rhel-server-optional-rpms subscri
Hi,
On Wed, 2013-02-13 at 17:27 +0900, Jeffrey Jones wrote:
> I have run the commands as you specified but unfortunately the error
> pops up again when I run yum makecache.
Same error? That is *almost* impossible -- makecache is the parameter to
get rid of that error, not to see that error. Co
Actually, the URL for the meta-data file is right there in the error
message.
I will do a wget and see if I can see anything obviously wrong.
On 13/02/13 17:27, Jeffrey Jones wrote:
Hello Devrim
I have run the commands as you specified but unfortunately the error
pops up again when I run yum
Hello Devrim
I had to type from console to so maintain formatting I put it on a paste
site:
https://gist.github.com/rurounijones/4943156
I have to leave the office in a moment unfortunately so I will be back
in about 18 hours.
Thanks
Jeff
On 13/02/13 17:31, Devrim GÜNDÜZ wrote:
Hi,
On
On Tue, Feb 12, 2013 at 8:05 AM, Silk Parrot wrote:
> Hi Hackers,
>
> I am interested in writing a FDW. I setup my environment on Windows.
> However, I am not able to figure out how to build FDW successfully. Here is
> what I have done:
>
> -Install the 9.2.2 by using EnterpriseDB installer.
Hi.
I'm unable to offload my backups to one of my PG 9.1 hot standbys
using purely streaming replication. After a few hours, usually on the
same large table, pg_dump is failing with 'ERROR: canceling statement
due to conflict with recovery'.
>From my reading from the documentation, this should n
John R Pierce wrote:
> Oracle supports a Netapp Filer with NFSv4, and a specific set of
> configurations.they don't support anything else NFS last I heard.
> whats good for Oracle is generally good for Postgres.
Oracle supports NFS everywhere except on Windows.
The new "direct NFS" feature (wh
David Sahagian wrote:
> Version=9.1.7
>
> INFO: clustering "my_cool_table" using sequential scan and sort
> INFO: "my_cool_table": found 1 removable, 1699139 nonremovable row versions
> in 49762 pages
> Detail: 1689396 dead row versions cannot be removed yet.
> CPU 9.80s/4.98u sec elapsed 175.92
krz...@gmail.com escribió:
> Year has passed and still no answer here or in documentation. I wonder
> if I get to live that long so I can find out answer.
The question was:
> Ok, but can someone comment, document something on security of
> installing extensions for normal users? Does allowing ac
Hi,
We're facing a weird performance problem in one of our PostgreSQL servers
running 8.0.26.
What can explain the difference between calling same query inside and
outside a cursor? If we run the query outside a cursor we got a response
time of 755ms and 33454ms if we call the same query inside a
Hi,
As we suspected the SELECT inside a cursor is using a different plan than
outside a cursor:
pgipm=# explain analyze DECLARE CUR1 CURSOR FOR
pgipm-# SELECT XMAX, ANO, MES, CODFUNC, SEQFUNC, TIPOPGTO, CODPD, HRSPD,
VLRPD, MESANO, TIPOCALCFERIAS, VLRBASE FROM fparq.cadpagwhere (ANO
>'2013')
Hi:
Looking for a table or view which contains the list of arguments that are
passed to a stored procedure. Doesn't seem to be in pg_proc.prosrc or other
pg_proc columns.
Thanks in Advance for any help.
Carlos Henrique Reimer wrote:
> We're facing a weird performance problem in one of our PostgreSQL servers
> running 8.0.26.
Ouch.
8.0 has been out of support since October 2010, and
I am afraid that might be a problem for you.
> What can explain the difference between calling same query inside a
Hello
2013/2/13 Gauthier, Dave :
> Hi:
>
>
>
> Looking for a table or view which contains the list of arguments that are
> passed to a stored procedure. Doesn't seem to be in pg_proc.prosrc or other
> pg_proc columns.
>
It is in pg_proc - argument's description is stored in combination of
fields
On 02/13/2013 06:13 AM, Gauthier, Dave wrote:
Hi:
Looking for a table or view which contains the list of arguments that
are passed to a stored procedure. Doesn't seem to be in pg_proc.prosrc
or other pg_proc columns.
Thanks in Advance for any help.
http://www.postgresql.org/docs/9.2/interact
Dave Gauthier wrote:
> Looking for a table or view which contains the list of arguments that are
> passed to a stored
> procedure. Doesn't seem to be in pg_proc.prosrc or other pg_proc columns.
This information is in the following columns of pg_proc:
proargtypes, proallargtypes, proargmodes, pro
Excellent !
Thank You very much !
-Original Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: Wednesday, February 13, 2013 9:30 AM
To: Gauthier, Dave; pgsql-general@postgresql.org
Subject: RE: How to get stored procedure args list from metadata tables ?
Dave Gauthier wr
Actually, how do you discriminate between 2 different procedures that have the
same name but different number of args (using pg_get_function_arguments)? The
function bocks when the procedure name is not unique.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sen
Hello,
As per the topic is it possible to set archive_mode and archive_command on a
server which is configured as a streaming replication hot standby?
I've tried and it doesn't seem to work, so I'm guessing maybe it's disabled.
Cheers,
James
--
View this message in context:
http://postgresql
james.sewell wrote:
> As per the topic is it possible to set archive_mode and archive_command on a
> server which is configured as a streaming replication hot standby?
>
> I've tried and it doesn't seem to work, so I'm guessing maybe it's disabled.
It works fine, only the server will not generate
Hi,
On Wed, 2013-02-13 at 17:49 +0900, Jeffrey Jones wrote:
> I had to type from console to so maintain formatting I put it on a
> paste site:
>
> https://gist.github.com/rurounijones/4943156
This is interesting:
Error: failure: repodata/primary.sqlite.bz2 from pgsg92: [Errno] No more
mirrors
On Feb 11, 2013, at 8:18 PM, John R Pierce wrote:
> are you sure it requires this old version? most software works with newer
> versions with little or no changes.
There are some implicit casting changes that broke some of my code
when 8.2 came out. Ever since then there have been no issues f
Hi,
I`m trying to figure out why a query runs in 755ms in the morning and
20054ms (26x) in the evening.
_
Mornin
Some issues are just funny.
Maybe lots of inserts deletes during the day?
Vacuum/analyze timing may have an impact on the planner?
Try again morning evening with vac/ana commands before the query.
Op 13-2-2013 19:42, Carlos Henrique Reimer schreef:
Hi,
I`m trying to figure out why a query run
Carlos Henrique Reimer wrote:
> I`m trying to figure out why a query runs in 755ms in the morning
> and 20054ms (26x) in the evening.
I would make autovacuum settings much more aggressive, or schedule
periodic VACUUM and/or ANALYZE runs during the day.
> database size is 40GB and memory 64GB
Kevin Grittner writes:
> Carlos Henrique Reimer wrote:
>> I`m trying to figure out why a query runs in 755ms in the morning
>> and 20054ms (26x) in the evening.
> I would make autovacuum settings much more aggressive, or schedule
> periodic VACUUM and/or ANALYZE runs during the day.
I'm wonder
Tom Lane wrote:
> I'm wondering about cache effects, ie memory already contains
> desired pages in the morning (perhaps as a side-effect of queries
> run overnight) and not so much by the evening. If so it's not
> clear that additional VACUUM activity would make things better.
>
> But in any cas
What does the following query give you on the standby ?
select * from pg_settings where category = 'Replication / Standby Servers';
On Wednesday, February 13, 2013 03:53:33 PM Stuart Bishop wrote:
> 'hot_standby_feedback = on'
--
postgresql.org.mx
--
Sent via pgsql-general mailing list (pgsql
On Wed, Feb 13, 2013 at 10:42 AM, Carlos Henrique Reimer
wrote:
> Hi,
>
> I`m trying to figure out why a query runs in 755ms in the morning and
> 20054ms (26x) in the evening.
>
>
> Morning:
>
> Sort (cost=151845.90..152304.21 rows=183322 width=62) (actual
> time=706.676..728.080 rows=32828 loop
Hi,
Anyway it does not seam related to statistics as the query plan is exactly
the same for both scenarios, morning and evening:
Will include the EXPLAIN ANALYZE again here:
___
Morning:
pgipm=# explain a
Carlos Henrique Reimer wrote:
> Another example that could help is this seqscan:
>
> explain analyze select sittrib8 from iparq.arript where sittrib8=33;
>
> In the evening:
> Fri Feb 8 14:00:01 BRST 2013
>
> QUERY
> PLAN
> --
Carlos Henrique Reimer wrote:
> Anyway it does not seam related to statistics as the query plan
> is exactly the same for both scenarios, morning and evening:
> Morning:
> Index Scan using pagpk_aux_mes, pagpk_aux_mes, pk_cadpag,
> pk_cadpag, pk_cadpag, pagchavefunc00 on cadpag
> Evening
On Wed, Feb 13, 2013 at 8:23 PM, Carlos Henrique Reimer <
carlos.rei...@opendb.com.br> wrote:
>
> I've used this query just as an example but the general feeling is that
> everything takes more time to process in the evening. Evening is also the
> period with more tasks in the the database.
>
>
Wh
Carlos Henrique Reimer writes:
> Will include the EXPLAIN ANALYZE again here:
>-> Index Scan using pagpk_aux_mes, pagpk_aux_mes, pk_cadpag, pk_cadpag,
> pk_cadpag, pagchavefunc00 on cadpag (cost=0.00..131521.88 rows=183322
> width=62) (actual time=0.664..614.080 rows=32828 loops=1)
BTW, I
Hi,
I'd like to do something which I think should be quite easy - that is join
2 tables and create a new table.
Table A postcode_input has columns which include postcode, eastings,
northings. there are 1,687,605 rows.
Table B bng_lat_long has columns lat, lon, e, n. There are 1,687,605 rows.
eas
Sorry for the confusion, the plans from morning and evening are really
different for sure.
Let me ensure with my team that postgresql configuration is not changed
between morning and evening and will recollect the data tomorrow.
On Wed, Feb 13, 2013 at 8:34 PM, Kevin Grittner wrote:
> Carlos H
On Wed, Feb 13, 2013 at 3:01 PM, Andrew Taylor wrote:
> And ended up with a table 13,708,233 rows long with what looks like plenty
> of duplicated rows. Some but not all are duplicated. What can I do to sort
> this out?
It means that (e, n) pairs are not unique in A and B and you got a
superposit
On Wed, Feb 13, 2013 at 2:53 PM, Tom Lane wrote:
> Carlos Henrique Reimer writes:
>> Will include the EXPLAIN ANALYZE again here:
>
>>-> Index Scan using pagpk_aux_mes, pagpk_aux_mes, pk_cadpag, pk_cadpag,
>> pk_cadpag, pagchavefunc00 on cadpag (cost=0.00..131521.88 rows=183322
>> width=62)
Hi Devrim
Damn, sorry that was a typo, I had to manually copy the output, sorry.
Thanks
Jeff
On 14/02/13 01:08, Devrim GÜNDÜZ wrote:
Hi,
On Wed, 2013-02-13 at 17:49 +0900, Jeffrey Jones wrote:
I had to type from console to so maintain formatting I put it on a
paste site:
https://gist.gith
On Wed, Feb 13, 2013 at 12:53 AM, Stuart Bishop wrote:
> I'm unable to offload my backups to one of my PG 9.1 hot standbys
> using purely streaming replication. After a few hours, usually on the
> same large table, pg_dump is failing with 'ERROR: canceling statement
> due to conflict with recover
On Mon, Feb 11, 2013 at 11:36 AM, Wells Oliver wrote:
> What's the canonical way of doing this? Various failed attempts include:
Just compare an empty hstore with yours.
[local]:5432 grayhemp@grayhemp=# select ''::hstore = ''::hstore,
''::hstore = '{a=>1}'::hstore;
?column? | ?column?
-
On Tuesday, February 12, 2013, Sahagian, David wrote:
> Version=9.1.7
>
> ** **
>
> INFO: clustering "my_cool_table" using sequential scan and sort
>
> INFO: "my_cool_table": found 1 removable, 1699139 nonremovable row
> versions in 49762 pages
>
> Detail: 1689396 dead row versions ca
On Wed, Feb 13, 2013 at 5:17 PM, Aleksey Tsalolikhin
wrote:
> Below is an example of feeding query output to gnuplot without leaving psql.
> I'd like to call it as "select graph(select * from example)", just for fun.
> What do I need to learn to do that, please? Can I create a function that
> use
2013/2/14 Aleksey Tsalolikhin :
> Below is an example of feeding query output to gnuplot without leaving
psql.
> I'd like to call it as "select graph(select * from example)", just for
fun.
> What do I need to learn to do that, please? Can I create a function that
> uses "\o"? I think not, because
On Thu, Feb 14, 2013 at 5:20 AM, René Romero Benavides
wrote:
> What does the following query give you on the standby ?
> select * from pg_settings where category = 'Replication / Standby Servers';
name | setting
--+-
hot_standby
On Thu, Feb 14, 2013 at 7:21 AM, Sergey Konoplev wrote:
> On Wed, Feb 13, 2013 at 12:53 AM, Stuart Bishop
> wrote:
>> I'm unable to offload my backups to one of my PG 9.1 hot standbys
>> using purely streaming replication. After a few hours, usually on the
>> same large table, pg_dump is failing
On Wed, Feb 13, 2013 at 8:59 PM, Stuart Bishop wrote:
> Something that might be interesting that I neglected to mention, the
> DETAIL of the error message is random; on production my failures end
> up with one of these three:
>
> DETAIL: User query might have needed to see row versions that must
48 matches
Mail list logo
