Re: [GENERAL] Move rows from one database to other

2017-02-21 Thread William Ivanski
the satellite databases? > > > > > - inserts can happen during syncing. > > Can UPDATEs happen? > > > - Network can break during syncing. > > - inserts into the central table can break (e.g. disk full): No loss at > > the satellite database must happen. > > - ... > > > > How to solve this with PostgreSQL? > > > > Regards, > > Thomas Güttler > > > > > > > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- William Ivanski - Microsoft MVP

Re: [GENERAL] migrate Sql Server database to PostgreSql

2017-01-18 Thread William Ivanski
All, > > I am using postgres 9.5 enterprise edition. > > i want to to how to migrate Sql Server database to PostgreSql. what are > the things required for migration and what are the cron and prons of > migration. > > -Pawan > -- William Ivanski - Microsoft MVP

Re: [GENERAL] Importing SQLite database

2016-12-08 Thread William Ivanski
d I will try to clarify further. > > Thank you. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- William Ivanski

Re: [GENERAL] Postgres Traffic accounting

2016-12-05 Thread William Ivanski
ic network of postgres sort by query? > > best regards > basti > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- William Ivanski

Re: [GENERAL] Trim performance on 9.5

2016-11-18 Thread William Ivanski
I just ran EXPLAIN ANALYZE, please see images attached. Field doesn't have a index. Em sex, 18 de nov de 2016 às 12:16, vinny <vi...@xs4all.nl> escreveu: > On 2016-11-18 15:06, William Ivanski wrote: > > Hi, > > > > I recently did major improvements on perfomance on

[GENERAL] Trim performance on 9.5

2016-11-18 Thread William Ivanski
? Thanks in advance. -- William Ivanski -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Strange? BETWEEN behaviour.

2016-10-20 Thread William Ivanski
> > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- William Ivanski

[GENERAL] OmniDB 1.6

2016-10-12 Thread William Ivanski
from the community. Thanks in advance! -- William Ivanski