Re: [GENERAL] Copy the database..

On Nov 2, 5:30 pm, Sascha Bohnenkamp <[EMAIL PROTECTED]> wrote: > if you dump/undump using a pipe there is no temp file ... > > Abandoned schrieb: > > > > > On Nov 2, 3:49 pm, Sascha Bohnenkamp <[EMAIL PROTECTED]> wrote: > >> maybe pg_dump | pg_undu

Re: [GENERAL] Copy the database..

On Nov 2, 3:49 pm, Sascha Bohnenkamp <[EMAIL PROTECTED]> wrote: > maybe pg_dump | pg_undump could work? > > I mean pg_dump with the appropriate parameters and undump directly to > the other database? > > This may one of the fastest ways to do it I think. > > Aband

[GENERAL] Copy the database..

Hi.. I want to copy my database.. I have a database which is name db01 and i want to copy it as name db01copy ? How can i do this ? This database is very big 200GB so i want to the fastest way. Also if you suggest pg_dump how can i remove the dump data after copying ? Note: I have a root account wi

[GENERAL] Which index can i use ?

Hi.. I want to do index in postgresql & python. My table: id(int) | id2(int) | w(int) | d(int) My query: select id, w where id=x and id2=y (sometimes and d=z) I have too many insert and select operation on this table. And which index type can i use ? Btree, Rtree, Gist or Hash ? Also I want to un

[GENERAL] Select too many ids..

Hi.. I have a id list and id list have 2 million dinamic elements.. I want to select what id have point.. I try: SELECT id, point FROM table WHERE id in (IDLIST) This is working but too slowly and i need to performance.. I'm sorry my bad english. King regards.. ---(end