On Tue, Oct 31, 2006 at 19:05:58 +0800,
nineday <[EMAIL PROTECTED]> wrote:
> I have a trouble.
> My DBMS is PostgreSQL which is accessory to Red hat 9.0.
> At the initial stages, it was very quick when select ,but operated for
> several months , it become to very slow ,especially in a pivotal ta
be re-used, and your
statistics get updated in the db system catalog.
--
Husam
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
ninedaySent: Tuesday, October 31, 2006 3:06 AMTo:
pgsql-admin@postgresql.orgSubject: [ADMIN] I have a question about
Database management
I h
You need to vacum (probably re-index) your tables
periodically to get the best performance.
These vacuming and indexing tools should already
be there with your PostgreSQL installation.
--Imad
www.EnterpriseDB.com
On 10/31/06, nineday <[EMAIL PROTECTED]> wrote:
I have a trouble.
My DBMS is Pos
I have a trouble.My DBMS is PostgreSQL which is accessory to Red hat 9.0.
At the initial stages, it was very quick when select ,but operated for several months , it become to very slow ,especially in a pivotal table.So,I exported data ,and recreate tables , finally import data, it get right .
t: Re: [ADMIN] I have a question?
cruise0078 wrote:
> Dear Firends:
> Now I want to migrate all data from MySQL to PostGRESQL.There are
> hands of tables in MySQL.I want to to know if there are some tools to
> help me to do that.Also I want to know the key point to finish that
> process
cruise0078 wrote:
> Dear Firends:
> Now I want to migrate all data from MySQL to PostGRESQL.There are
> hands of tables in MySQL.I want to to know if there are some tools to
> help me to do that.Also I want to know the key point to finish that
> process and how much time it may take! Very Thanks!
>
ehalf Of
cruise0078Sent: Friday, 07 April, 2006 5:35 amTo:
pgsql-admin@postgresql.orgSubject: [ADMIN] I have a
question?
Dear Firends:Now I want to migrate all data from MySQL to
PostGRESQL.There are hands of tables in MySQL.I want to to know if there are
some tools to help me to do that.Also I
Dear Firends:Now I want to migrate all data from MySQL to PostGRESQL.There are hands of tables in MySQL.I want to to know if there are some tools to help me to do that.Also I want to know the key point to finish that process and how much time it may take! Very Thanks!
help me please, I am using Postgresql, I want to know
if exists a limit in the number of rows to create a
function. I created a function using pgaccess, but
when I try to see it using PgAdmin, I can not see all
the lines I wrote. Thank you for your answers. I am
writting from Colombia (I am still
