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
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
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.
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
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 Tue, Feb 12, 2013 at 8:05 AM, Silk Parrot silkpar...@gmail.com 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
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
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 (where
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 sec.
My
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
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
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 and
Hello
2013/2/13 Gauthier, Dave dave.gauth...@intel.com:
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
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.
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,
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
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]
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:
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 to
On Feb 11, 2013, at 8:18 PM, John R Pierce pie...@hogranch.com 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
Hi,
I`m trying to figure out why a query runs in 755ms in the morning and
20054ms (26x) in the evening.
_
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
Carlos Henrique Reimer carlos.rei...@opendb.com.br 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
Kevin Grittner kgri...@ymail.com writes:
Carlos Henrique Reimer carlos.rei...@opendb.com.br 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
Tom Lane t...@sss.pgh.pa.us 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.
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
On Wed, Feb 13, 2013 at 10:42 AM, Carlos Henrique Reimer
carlos.rei...@opendb.com.br 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
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
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 carlos.rei...@opendb.com.br 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,
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.
What do
Carlos Henrique Reimer carlos.rei...@opendb.com.br 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
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.
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 kgri...@ymail.com
On Wed, Feb 13, 2013 at 3:01 PM, Andrew Taylor andydtay...@gmail.com 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
On Wed, Feb 13, 2013 at 2:53 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Carlos Henrique Reimer carlos.rei...@opendb.com.br 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
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:
On Wed, Feb 13, 2013 at 12:53 AM, Stuart Bishop stu...@stuartbishop.net 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
On Mon, Feb 11, 2013 at 11:36 AM, Wells Oliver wellsoli...@gmail.com 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?
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 cannot be
On Wed, Feb 13, 2013 at 5:17 PM, Aleksey Tsalolikhin
atsaloli.t...@gmail.com 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
2013/2/14 Aleksey Tsalolikhin atsaloli.t...@gmail.com:
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
On Thu, Feb 14, 2013 at 5:20 AM, René Romero Benavides
ichbinr...@gmail.com wrote:
What does the following query give you on the standby ?
select * from pg_settings where category = 'Replication / Standby Servers';
name | setting
--+-
On Thu, Feb 14, 2013 at 7:21 AM, Sergey Konoplev gray...@gmail.com wrote:
On Wed, Feb 13, 2013 at 12:53 AM, Stuart Bishop stu...@stuartbishop.net
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
On Wed, Feb 13, 2013 at 8:59 PM, Stuart Bishop stu...@stuartbishop.net 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
48 matches
Mail list logo