Hello,
Does anyone which is a more accurate estimate of a table's live
rows: pg_class.reltuples (
http://www.postgresql.org/docs/current/static/catalog-pg-class.html)
OR pg_stat_all_tables.n_live_tup (
http://www.postgresql.org/docs/current/static/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW)?
William Dunn dunn...@gmail.com writes:
Does anyone which is a more accurate estimate of a table's live
rows: pg_class.reltuples (
http://www.postgresql.org/docs/current/static/catalog-pg-class.html)
OR pg_stat_all_tables.n_live_tup (
Thanks so much Tom!
*Will J. Dunn*
*willjdunn.com http://willjdunn.com*
On Wed, Jun 17, 2015 at 3:48 PM, Tom Lane t...@sss.pgh.pa.us wrote:
William Dunn dunn...@gmail.com writes:
Does anyone which is a more accurate estimate of a table's live
rows: pg_class.reltuples (
Hi list,
I am happy to announce the new release of pg_idx_advisor version 0.1.2.
This is a PostgreSQL extension which allows a user to get index advice from
the DB optimizer.
It's the first stable release so please don't go running this on your
production environment :)
But, I'd greatly
hi there!
for me case listed below looks like something goes wrong (at least very strange)
pg 9.2.10
* schema:
base_table == inheritance_with_before_trigger == child_table ==
audit_after_trigger == child_table_log
* init sql:
create schema tmp;
--create extension hstore;
-- inheritance part
On Wed, 17 Jun 2015 15:24 Xavier 12 mania...@gmail.com wrote:
On 17/06/2015 03:17, Sameer Kumar wrote:
On Tue, 16 Jun 2015 16:55 Xavier 12 mania...@gmail.com wrote:
Hi everyone,
Questions about pg_xlogs again...
I have two Postgresql 9.1 servers in a master/slave stream replication
On Wed, 17 Jun 2015 10:33:37 -0300
Anderson Valadares anderva...@gmail.com wrote:
2015-06-15 18:19 GMT-03:00 Bill Moran wmo...@potentialtech.com:
On Mon, 15 Jun 2015 17:48:54 -0300
Anderson Valadares anderva...@gmail.com wrote:
2015-06-12 19:56 GMT-03:00 Bill Moran
Indeed Bill, if drop the foreign key constraint on stuff_ext table
there are no failures at all...
But, since I can't remove the foreign key, how can I tell postgres that
he can trust it then?
Because it's obvious (for the code reader at least), that the other
transaction will not be
Filipe Pina filipe.p...@impactzero.pt wrote:
if drop the foreign key constraint on stuff_ext table there are
no failures at all…
It is my recollection that we were excluding the queries used to
enforce referential integrity constraints from the conflict
tracking, so I am surprised you are
On 17/06/2015 03:17, Sameer Kumar wrote:
On Tue, 16 Jun 2015 16:55 Xavier 12 mania...@gmail.com
mailto:mania...@gmail.com wrote:
Hi everyone,
Questions about pg_xlogs again...
I have two Postgresql 9.1 servers in a master/slave stream replication
(hot_standby).
On Wed, Jun 17, 2015 at 5:15 PM, 夏高 wrote:
I don't know why the files are not the same but tests all passed. Helps are
appreciated, thanks!
Some tests have multiple expected outputs. In the case of char, there
is not only char.out, but as well char_1.out and char_2.out. In your
case char_1.out
On 16/06/2015 22:28, Guillaume Lelarge wrote:
2015-06-16 15:55 GMT+02:00 Xavier 12 mania...@gmail.com
mailto:mania...@gmail.com:
I don't think so. There is no archive_command and the master doesn't
ship its wal here.
But how can I check that ?
What's the complete path to the
I downloaded psotgresql-9.4.4 source code and build it on Centos 6.5 x64
edition. Then I run 'make test' and it reported that 'All 145 tests
passed'. But the expected output and actual output of test 'char' are not
same.
The expected output of in 'src/test/regress/expected/char.out' is:
SELECT
Douglas Stetner wrote:
Looking for confirmation there is an issue with pg_dump failing after upgrade
to openssl-1.0.1e-
30.el6_6.11.x86_64 on redhat linux.
-bash-4.1$ pg_dump -V
pg_dump (PostgreSQL) 8.4.9
-bash-4.1$ pg_dump -h localhost -C Hogwarts -a -t mafs -f zz
pg_dump: Dumping the
Hi Kevin,
I have installed:
PostgreSQL 9.3.7 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
4.8.2-19ubuntu1) 4.8.2, 64-bit
But as you mentioned it should have been fixed in later versions, I've
upgraded to 9.4:
PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
2015-06-15 18:19 GMT-03:00 Bill Moran wmo...@potentialtech.com:
On Mon, 15 Jun 2015 17:48:54 -0300
Anderson Valadares anderva...@gmail.com wrote:
2015-06-12 19:56 GMT-03:00 Bill Moran wmo...@potentialtech.com:
Please do not remove the mailing list from replies. See below.
On Fri,
Indeed Bill, if drop the foreign key constraint on stuff_ext table I
get 0 failures...
But, since I can't remove the foreign key, how can I tell postgres that
he can trust it then?
Because it's obvious (for the code reader at least), that the other
transaction will not be responsible for
Hi all,
Looking for confirmation there is an issue with pg_dump failing after upgrade
to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux.
-bash-4.1$ pg_dump -V
pg_dump (PostgreSQL) 8.4.9
-bash-4.1$ pg_dump -h localhost -C Hogwarts -a -t mafs -f zz
pg_dump: Dumping the contents of table mafs
On 17/06/2015 02:44, Venkata Balaji N wrote:
On Tue, Jun 16, 2015 at 6:55 PM, Xavier 12 mania...@gmail.com
mailto:mania...@gmail.com wrote:
Hi everyone,
Questions about pg_xlogs again...
I have two Postgresql 9.1 servers in a master/slave stream replication
(hot_standby).
Douglas Stetner stet...@icloud.com writes:
Looking for confirmation there is an issue with pg_dump failing after
upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux.
Quick thought --- did you restart the Postgres service after upgrading
openssl? If not, your server is still using
20 matches
Mail list logo