Thank you all,
I did look at the log , I enabled pg_stat_statements , however it showed
the buffers, scans and other info about the query execution - not the
records number, any idea how can I get it?
I agree that the problem is in qty of the queries,
will investigate the client.
thank yo
Hello,
I'm trying to capture amount of data moving from client app to the server &
back.
The client is executable (c#) gue on windows, server is lunix centOS,
PostgreSQL 8.4.
We see serious performance difference between execution via LAN & VPN.
I enabled the logging and used pgFouine to anal
Thank you, I will look at skype's walmgr.
Also could you explain what makes it "hands free administration" 9.0?
Is the shipping of the wal file from the master to HA instance automated ?
Any error checking /self recovery?
thank you much for the suggestion.
Helen
--
View this message in con
Hello,
I need to implement HA for the appliance that is sold to the customer - our
application has no DBA and must be very stable and self recoverable.
We are running PostgreSQL 8.4.
Is the warm standby a good solution for us?
Thank you for all the suggestions.
Helen
--
View this messag
Hi Chetan,
I'm not sure how I can create a test case, I'm running queryes on 50g of
data to see this.
My general questions are about locking children when select from a parent, I
have not seen any documentation on it. Does any parameter like 'concurrent
read' exist? I'm still new to postgres, c
Hello,
I’m having a problem with concurrent processing.
2 queries are accessing the same parent table that have 24 partitions.
I see “shared lock is not granted “ for one of them on one of the children
while the other query is running.
Does the “ select from a parent table” make a lock on the
I've got it now - it will be 0/empty for a table in "default tablespace", if
the table has been created in a different tablespace - it will show the
name.
thank you!.
Helen
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-to-find-a-tablespace-for-the-table-tp450020
that is exactly the case - application_category table is in "profiler1"
tablespace as well as all tables in my "profilre1" database.
I'm not sure how to "update catalog"... vacuum ?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-to-find-a-tablespace-for-the-t
profiler1=# select relname,reltablespace from pg_class where
relname='application_category';
relname| reltablespace
--+---
application_category | 0
(1 row)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-to-
here it is :
profiler1=# select oid,* from pg_tablespace;
oid | spcname | spcowner | spclocation | spcacl
---++--+--+
1663 | pg_default | 10 | |
1664 | pg_global | 10 | |
well,
here is the query :
profiler1=# select relname,reltablespace from pg_class where reltablespace
in(select oid from pg_tablespace where spcname not in
('pg_default','pg_global'));
relname | reltablespace
-+---
why it shows no records?
profiler1=# select * from pg_cat
thank you Greg,
here is what I get, I createed view as you suggested.
I'm not sure why tablespace column is empty
profiler1=# select * from pg_tables where schemaname ='public' limit 10;
schemaname |tablename| tableowner | tablespace | hasindexes
| hasrules | hastri
ers
hello,
I'm looking into pg_tables view and only one tablespace is displayed is
pg_global.
All my tables are created in my custom tablespace and that column is empty
for them.
select * from pg_tablespace show my tablespace, pgAdmin shows that
tablespace for each table. I need to query the data di
You are right to the point, Tom.
The datex is timestamp with time zone and the constraints were created as
timestamp without time zone.
As soon as I fixed that , it all started working.
thank you!
Helen
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/constraint-partition
sorry, my table has many columns and missed the datex when make it look
smaller.
datex is the column in the table. This is the driving constraint.
My task is to have 30 days of data with 5mln to 10 mln rec in 1 hour table,
so I partition it by hour table and combine them into days, which are
combi
15 matches
Mail list logo
