Postgres Pro
Downloads
Home   >   mailing lists

Thread: how to see how the data is structured in postgreqsql

how to see how the data is structured in postgreqsql

From
zhang zhengquan
Date:
Hi, There,

I am  a new sysadmin and I am new to postgresql and database. I have got
a very old gentoo server that has been running postgresql db for years
and now the log files alone are about 10 Giga bytes.

 we run apache server and we have a ruby script that parse the
access_log of apache and put the access data in to this db. the script
runs daily in a cron job.

Now the problem is, since we did not rotate the access_log generated by
apache , access_log is getting so big that each day the parsing job of
the log file and data entry in to the db takes hours to finish and it
eats a lot of cpu resources and puts great pressure on the old server.

I would like to know how the my log data is organized in the database
and then I will see if I can do something to optimize the data entry
into the db.

Any pointers is greatly appreciated.

Zhengquan

Re: how to see how the data is structured in postgreqsql

From
Raymond O'Donnell
Date:
On 31/03/2009 16:58, zhang zhengquan wrote:
> I would like to know how the my log data is organized in the database
> and then I will see if I can do something to optimize the data entry
> into the db.

pgAdmin is a really good tool that lets you see all the objects in your
database in a tree view:

   www.pgadmin.org


Alternatively, you could use \d at the psql command line.

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Re: how to see how the data is structured in postgreqsql

From
zhang zhengquan
Date:
Thank you so much Ray, I will give it a go.
Z

2009/3/31 Raymond O'Donnell <rod@iol.ie>:
> On 31/03/2009 16:58, zhang zhengquan wrote:
>> I would like to know how the my log data is organized in the database
>> and then I will see if I can do something to optimize the data entry
>> into the db.
>
> pgAdmin is a really good tool that lets you see all the objects in your
> database in a tree view:
>
>   www.pgadmin.org
>
>
> Alternatively, you could use \d at the psql command line.
>
> Ray.
>
>
> ------------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod@iol.ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>