On Tue, Feb 15, 2005 at 08:50:53AM -0300, Ricardo Valença de Assis wrote:
>
> I'm trying to migrate a database from one server to another but I got
> a hard problem. All the tables and sequences are migrated but the field
> last_value of ALL sequences is set to 1. Why this? The others fields of
>
On Tue, 2005-02-15 at 15:21, Joel Fradkin wrote:
> Us? :) Can you provide some more details?
>
> Hardware configuration,
> Dell 6560 4 processor, 8 gig memory, I think I have Postgres on two raids
four processors, or two hyperthreaded cpus? My experience has been that
hyperthreading usually
Us? :) Can you provide some more details?
Hardware configuration,
Dell 6560 4 processor, 8 gig memory, I think I have Postgres on two raids
separate from the OS (pgsql is a raid 10 4 10kdrive array) and /wal is 2 15k
drives). I am running postgres 8 and am using the conf in
/var/lib/pgslq/data
I think Joel may be asking for a paid, dedicated consultant. Could be
wrong, but I know you folks are out there. --Rick
"Marc G. Fou
On Tue, 15 Feb 2005, Joel Fradkin wrote:
Hi,
I am trying to get postgres working on a Dell and am finidng my SQL queries
run incrediably slow.
I have tried to adjust cache and buffers, etc with no luck.
Any advice on who would be best for help either it's a config issue or a
query issue etc.
Us? :
On Tue, 2005-02-15 at 14:12, Joel Fradkin wrote:
> Hi,
>
>
>
> I am trying to get postgres working on a Dell and am finidng my SQL
> queries run incrediably slow.
>
> I have tried to adjust cache and buffers, etc with no luck.
>
> Any advice on who would be best for help either itâs a config
Clinging to sanity, [EMAIL PROTECTED] (Dick Davies) mumbled into her beard:
> Is there a neat way to clean out a database via SQL commands?
>
> i.e. get rid of tables, sequences, integers, etc.
>
> At present I'm using dropdb/createdb, but thats' far from ideal
> and I think it's causing postgres t
Hi,
I am trying to get postgres working on a Dell and am finidng
my SQL queries run incrediably slow.
I have tried to adjust cache and buffers, etc with no luck.
Any advice on who would be best for help either it’s a
config issue or a query issue etc.
I been trying for a few weeks
If there are any foreign key constraints, you'll have to truncate the
tables in the appropriate order. You would also have to reset the
sequence values as well.
Naomi Walker wrote:
How about just truncating all the tables?
Dick Davies wrote:
* Tom Lane <[EMAIL PROTECTED]> [0232 16:32]:
How about just truncating all the tables?
Dick Davies wrote:
> * Tom Lane <[EMAIL PROTECTED]> [0232 16:32]:
>
>>Dick Davies <[EMAIL PROTECTED]> writes:
>>
>>>Is there a neat way to clean out a database via SQL commands?
>>>i.e. get rid of tables, sequences, integers, etc.
>>
>>>At present I'm u
* Tom Lane <[EMAIL PROTECTED]> [0232 16:32]:
> Dick Davies <[EMAIL PROTECTED]> writes:
> > Is there a neat way to clean out a database via SQL commands?
> > i.e. get rid of tables, sequences, integers, etc.
>
> > At present I'm using dropdb/createdb, but thats' far from ideal
> > and I think it's
Dick Davies <[EMAIL PROTECTED]> writes:
> Is there a neat way to clean out a database via SQL commands?
> i.e. get rid of tables, sequences, integers, etc.
> At present I'm using dropdb/createdb, but thats' far from ideal
> and I think it's causing postgres to do more mork than it needs to...
Wel
Is there a neat way to clean out a database via SQL commands?
i.e. get rid of tables, sequences, integers, etc.
At present I'm using dropdb/createdb, but thats' far from ideal
and I think it's causing postgres to do more mork than it needs to...
--
'My life, and by extension everyone else's, i
On Tue, 2005-02-15 at 09:14, Zouari Fourat wrote:
> Hello
> am new to transactional sql (just moved from mysql) and would like to
> use transactions and i want to ask about it here, when am in a
> transaction block can i execute other queries on the server (that
> table exactly) or shoudl i commit
Hello
am new to transactional sql (just moved from mysql) and would like to
use transactions and i want to ask about it here, when am in a
transaction block can i execute other queries on the server (that
table exactly) or shoudl i commit the transaction to free the table ?
---
Hello World!
I´m trying to migrate a database
from one server to another but I got a hard problem. All the tables
and sequences are migrated but the field last_value of ALL sequences is set to
1. Why this? The others fields of them are set correctly but last_value it not.
Is there a wa
16 matches
Mail list logo
