Hi,
We have several users working on a 8.4 database, using it as a
back-end for several related apps and transfering data to and from it.
The database tends to get a bit messy, so i've made a little table to
provide an overview.
This table is truncated and refilled daily, it shows all tables and
v
Ok, so 300 times the statistics target!
Thanks a lot for the exact code and formula!
On Mon, Aug 1, 2011 at 4:49 PM, Tom Lane wrote:
> Why? This is purely an implementation detail. From the user's
> viewpoint, either the stats are good enough or they're not --- the exact
> number of rows sample
Hi,
I'ver been wondering how to set the number of rows that are scanned by
analyze. (I want to increase it)
I couln't find it at first but when i read closer i found that is does:
"The largest statistics target among the columns being analyzed
determines the number of table rows sampled to prepare
Hi,
Is there a way to find out how much work_mem my server(*) is actually
using on a running system in production?
* - session or cluster. I don't mean explain analyze.
What i am really interested in is: how does postgres utilize the
memory in the server? How much goes where, in reality.
I want t
Then, are the index scans counted in a memory variable and written at
analyze time?
On Thu, May 12, 2011 at 8:22 PM, raghu ram wrote:
>
> "Analyze" activity will update the statistics of each catalog table.
> --Raghu Ram
>
>
--
"Patriotism is the conviction that your country is superior to al
Hi,
We have some indexes that don't seem to be used at all.
I'd like to know since when they have not been used.
That is, the time when postgres started counting to reach the number that is
in pg_stat_user_indexes.idx_scan
Is there a way to retrieve that from the database ?
Cheers,
WBL
--
"Pa
Hi,
i've tested on 8.3 and 8.4 and i found that autovacuum works during restore
uin my test scenario, which is:
a new database wit two tables. tab1 has 1M recs, tab2 has 10 recs.
When i drop the database and restore, pg_stat_all tables tells me good
estimations for the number of live tuples.
But
BTW, is there a way to find out what particular configure options were used
for any given (binary) installation?
WBL
On Thu, Mar 24, 2011 at 2:11 PM, Willy-Bas Loos wrote:
> Hi,
>
> I'm not quite sure but it probably means that postgresql was not built with
> kerberos 5 supp
Hi,
I'm not quite sure but it probably means that postgresql was not built with
kerberos 5 support.
That would make sense if you are using a binary install (did not compile
from source), because of the notice at
http://www.postgresql.org/docs/9.0/interactive/auth-methods.html#KERBEROS-AUTH
"Note:
Hi,
I've encountered this before, psql gives me a syntax error for no clear
reason. It's allways on the first character of a sql file.
I think that there must be some strange character code at the first
position, maybe it is because i share a ntfs partition with the windows
installation on my lapt
cool actually.
any idea for the number of tuples?
count all lines after COPY .* ) FROM stdin;
until \.
(but how?)
on a side note: what's the difference between the admin list and the general
list?
--
"Patriotism is the conviction that your country is superior to all others
because you were born
> postgresql-server-dev-8.4?
ah, the other way around :P
i would think
libpqxx3-dev
or libpqxx-dev, which is probably a meta-package (independent of version nr)
it seems from the error that you don't need the server files, only
libpg, which is a client library
--
"Patriotism is the convictio
> I've installed postgresql 8.4.4.
Hi,
Usually you need a ...-dev package if you want to compile anything against it.
But i can't find a postgresql-8.4-dev in my ubuntu lucid (10.04).
That might mean that you have to compile postgres also, or find a
repository for the -dev package.
hth
WBL
--
"
> Note: I just learned from this change that with the 3x2 additional
> tables from the 2 new partitioned table the query of 8 becomes one with
> 14 joined tables
It seems then that you did not partition your tables in such a way
that your query only needs to scan one of them?
That is where partiti
>> time echo '\timing \\select * from table1 where id = 123;' | psql
>> In the above query. the 'timing' will time the database time and
>> the 'time' command at the very start will time the complete time
>> for the query including network time.
>
> No, the 'timing' will say how long it took to se
Good question. I hear about putting WAL/indexes/tables on separate spindles
and all that, but what if all IO is virtualized?
I would guess that IO and OS page cache would be the main issues here.
i haven't dared to put my db on a virtual box though, because i don't know
what happens inside of it.
16 matches
Mail list logo
