for profiling, you can also use the epqa.
http://epqa.sourceforge.net/
On Fri, Mar 13, 2009 at 3:02 AM, Laurent Laborde wrote:
> On Wed, Mar 11, 2009 at 11:42 PM, Frank Joerdens
> wrote:
> >
> > effective_cache_size= 4GB
>
> Only 4GB with 64GB of ram ?
>
> About logging, we have 3 p
Hi,
I have a 8 GB database, and 2 GB table. In a query i use the 2 GB table and
several other tables where it takes around 90 minutes for execution.
In different places, it takes drastically different time. Say everywhere i
have the same,
OS - Debian.
Primary memory - 3 GB
PostgreSQL configuratio
On Thu, Dec 4, 2008 at 7:38 PM, Franck Routier wrote:
> Hi,
>
> I am trying to restore a table out of a dump, and I get an 'out of
> memory' error.
>
> The table I want to restore is 5GB big.
>
> Here is the exact message :
>
> adm...@goules:/home/backup-sas$ pg_restore -F c -a -d axabas -t cabmnt
Dear All,
Recently i have released the next version of the epqa. which is a very
useful tool for, gives input for optimizing psql queries, and fine tuning
it.
epqa is tool similar like, pqa. But designed and implemented to parse log
files which is in GB's. Report is similar like that.
More inf
Dear All,
Am going to do migration of database from one version to another., is there
any article or any other document explaining the possibilities and other
things.
Further Explanation:
I have a database in postgres X.Y which has around 90 tables, and lot of
data in it.
In the next version of
Hi All,
This query is being executed nearly a million times
SELECT 'DBD::Pg ping test'
Why this is being executed ? What is the use ?
Am sure that this query is not executed explicitly.
am using postgres 8.1
Any idea ?
Hi,
I need to change the name of the constraint.,
What will be the best way to do this.
Am using postgres 8.1.
Is it possible to do the rename constraint( like renaming a column), i don't
know how to do this ?
Or i need to drop the constraint, and i need to create constraint with new
name, how
There is NO MAX
It is according to your hardware you have, and the db you have.
2008/4/3 bitaoxiao <[EMAIL PROTECTED]>:
>
> What can be set as max of postgreSQL shared_buffers and work_mem
>
> 2008-04-03
> --
> bitaoxiao
>
>
ay, but other queries is taking much time...
ok i ll do more experimentations and i ll be back
Very great thanks for all of your replies GUYZ.
>
> - Luke
>
>
>
> On 3/25/08 1:35 AM, "sathiya psql" <[EMAIL PROTECTED]> wrote:
>
> Dear Friends,
>
>
> Yes. It takes your hardware about 3 seconds to read through 700M of ram.
>
>
> Keep in mind that you're not just reading RAM. You're pushing system
> requests through the VFS layer of your operating system, which is treating
> the RAM like a disk (with cylinder groups and inodes and blocks
EXPLAIN ANALYZE SELECT count(*) from call_log_in_ram ;
QUERY
PLAN
--
Aggregate (cost=90760.80..90760.80 rows=
>
>
>
> Shows us the explain analyze. There is no problem with a large number
> of records, as long as you're not expecting to process all of them all
> the time.
yes many a times i need to process all the records,
often i need to use count(*)
so what to do ?? ( those trigger options i kn
>
> th maximum number of records in one PostreSQL table ist unlimited:
>
am asking for good performance, not just limitation..
If i have half a crore record, how the performance will be ?
>
> http://www.postgresql.org/about/
>
> [for some values of unlimited]
>
> Some further help:
>
> googling f
Ok, finally am changing my question.
Do get quick response from postgresql what is the maximum number of records
i can have in a table in postgresql 8.1 ???
On Tue, Mar 25, 2008 at 2:09 PM, jose javier parra sanchez <
[EMAIL PROTECTED]> wrote:
> It's been said zillions of times on the maillist. Using a select
> count(*) in postgres is slow, and probably will be slow for a long
> time. So that function is not a good way to measure perfomance.
>
Yes, bu
Dear Friends,
I have a table with 32 lakh record in it. Table size is nearly 700 MB,
and my machine had a 1 GB + 256 MB RAM, i had created the table space in
RAM, and then created this table in this RAM.
So now everything is in RAM, if i do a count(*) on this table it returns
327600 in 3
>
> OK, so your tables all have the same fields (columns), as if you used
> CREATE TABLE new_table ( LIKE some_template_table ) ?
It will contain some other unique columns for each table.
> meaning that they contain NULL values in that field for every record?
what is the value it may contain
Hi All,
I want some clarification in the following,
In a database which we are having we have nearly 100 tables, and in 75% of
the tables we have 6 columns ( INT ) as standard columns. What is standard
columns, if you create a table in this database you should have some default
6 columns in there
i thought many a replies will come... but only one..
common guys... it may be helping you in tuning your database indirectly,
post that tool also, give some informations such as
Tool Name: Schemaspy
Open Source: YES
Database: Postgres
URL: http://sourceforge.net/projects/schemaspy/1
Following can
hi all,
I want this mail to be continued about summary of performance tuning
tools... or other postgres related tools..
I ll start with saying there is a tool SCHEMASPY ( i got to know about this
from this group only ), this will draw ER diagram and gives interesting
informations about our postgre
>
> 14:31 < rtfm_please> For information about erd
> 14:31 < rtfm_please> see http://druid.sf.net/
> 14:31 < rtfm_please> or http://schemaspy.sourceforge.net/
A very great Thanks.
SchemaSpy drawn ER diagram by referring my database...
it done a very good job
Thanks a lot GUY
Is there any tool to draw ER diagram from SQL schema file...
no other groups are replying.
>
> you are talking about the debian home page right?
>
> --- no am talking about backports home page..
My question is that how to migrate my database to 7.4 to 8.1
that is not only dumping the db and extracting that in 8.1 ..
If i do that whether it will work without problem, or i have to do some
manual changes is my question...
In the home page itself they were saying testing ... unstable
then we should not use that for live.
so i prefer 8.1 .
>
> You can get 8.3 from backports: http://www.backports.org/ - it's a
> debian project to get more up to date versions for existing stable
> releases (they
>
> This might be a silly question, but ... why 8.1 ?
how it will be a silly question
I thought that some manual changes are required... so am asking this may
be argument for functions had changed.. or any other changes...
>
> --
> Craig Ringer
>
>
> This might be a silly question, but ... why 8.1 ?
>
> If you're doing a major upgrade, why not go straight to 8.3? It's been
> out long enough that there aren't any obvious nasty bugs, and there have
> been a fair few fixes and improvements since prior versions.
>
Because am using Debian ETCH s
Is there any article describing the migration database from postgresql 7.4to
8.1
>
> select usename,relname, tgname, tgtype, proname, prosrc, tgisconstraint,
> > tgconstrname, tgconstrrelid, tgdeferrable, tginitdeferred, tgnargs,
> > tgattr, tgargs from (pg_trigger join pg_class c on tgrelid=c.oid )
> > join pg_proc on (tgfoid=pg_proc.oid) join pg_user pu on
> > c.relowner=pu.u
thanks...
after this query also it is showing default triggers ( am very much worried
that how the system triggers are created using my username
ok i posted this in the group you specified..
On Tue, Mar 11, 2008 at 8:03 PM, Sergey Benner <[EMAIL PROTECTED]>
wrote:
> Again :) Try this query.
how to find trigger names in my database ?
using psql 7.4
the following query shows system triggers, i want only to list the
triggers created by me
select relname, tgname, tgtype, proname, prosrc, tgisconstraint,
tgconstrname, tgconstrrelid, tgdeferrable, tginitdeferred, tgnargs,
tgattr, tgargs
> Yes it is the latest stable version.
>
is there any article saying the difference between this 7.3 and 8.4
I had 50 lakh records in my table...
while counting that am using that row in where condition... which makes
problem, cpu is waiting for device...
Debian OS, postresql 7.4, 50 lakh records.
Query is
EXPLAIN ANALYZE select count(call_id) from call_log where call_id > 1;
while seeing the top, cp
>
> Actually it isn't obvious as oids have been deprecated for years.
no in my version it is now also available
>
>
> What version of ancient PostgreSQL are you running exactly?
postgresql 7.4
xplain., what is this COST, actual time and other stuffs
On Thu, Mar 6, 2008 at 12:27 PM, A. Kretschmer <
[EMAIL PROTECTED]> wrote:
> am Thu, dem 06.03.2008, um 12:17:55 +0530 mailte sathiya psql folgendes:
> > TRIGGER i can use if i want the count of the whole table, but i requ
i had a table with 50 lakh record...
it has a column called oid ( obviously all the tables will have this ), but
while doing any operation it is getting slow because of the number of
records...
if i remove the oid column will i get any benefit, what are all the other
default columns created witho
-- Forwarded message --
From: sathiya psql <[EMAIL PROTECTED]>
Date: Thu, Mar 6, 2008 at 12:17 PM
Subject: Re: [PERFORM] count * performance issue
To: "A. Kretschmer" <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
TRIGGER i can use if i want the count of the whol
is there any way to explicitly force the postgres to use index scan
On Thu, Mar 6, 2008 at 12:06 PM, A. Kretschmer <
[EMAIL PROTECTED]> wrote:
> am Thu, dem 06.03.2008, um 1:26:46 -0500 mailte Mark Mielke folgendes:
> >
> >
> > There aren't a general solution. If you realy need the exac
will you please tell, what is autovacuuming... and wat it ll do... is there
any good article in this
On Thu, Mar 6, 2008 at 11:56 AM, Shoaib Mir <[EMAIL PROTECTED]> wrote:
> On Thu, Mar 6, 2008 at 5:19 PM, sathiya psql <[EMAIL PROTECTED]>
> wrote:
>
> > buy every
buy every time i need to put ANALYZE...
this takes the same time as count(*) takes, what is the use ??
On Thu, Mar 6, 2008 at 11:45 AM, Shoaib Mir <[EMAIL PROTECTED]> wrote:
> On Thu, Mar 6, 2008 at 5:08 PM, A. Kretschmer <
> [EMAIL PROTECTED]> wrote:>
>
> > > am having a table with nearly 50 lak
count(*) tooks much time...
but with the where clause we can make this to use indexing,... what where
clause we can use??
Am using postgres 7.4 in Debian OS with 1 GB RAM,
am having a table with nearly 50 lakh records,
it has more than 15 columns, i want to count how many records are there, it
41 matches
Mail list logo
