Re: [GENERAL] pg_sample

2016-10-19 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > I may be overseeing something, but what about dependencies between > tables, sequencies, indexes, etc.? I guess that if one takes the first > 100 rows of a table referenced by another table, there is no guarantee > that in the first 100

Re: [GENERAL] pg_sample

2016-10-19 Thread Karsten Hilbert
On Wed, Oct 19, 2016 at 01:24:10PM +1300, Patrick B wrote: > I'm using pg_sample to do that, but unfortunately it doesn't work well. > It doesn't get the first 100 rows. It gets random 100 rows. > > Do you guys have any idea how could I do this? For any relevant answer to this question you'll

Re: [GENERAL] pg_sample

2016-10-18 Thread Adrian Klaver
On 10/18/2016 08:15 PM, Charles Clavadetscher wrote: Hello On 10/19/2016 04:58 AM, Greg Sabino Mullane wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Patrick B writes: ... However, this new database test server doesn't need to have all the data. I

Re: [GENERAL] pg_sample

2016-10-18 Thread Charles Clavadetscher
Hello On 10/19/2016 04:58 AM, Greg Sabino Mullane wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Patrick B writes: ... However, this new database test server doesn't need to have all the data. I would like to have only the first 100 rows(example) of

Re: [GENERAL] pg_sample

2016-10-18 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Patrick B writes: ... > However, this new database test server doesn't need to have all the data. I > would like to have only the first 100 rows(example) of each table in my > database. ... This should do what you

Re: [GENERAL] pg_sample

2016-10-18 Thread Melvin Davidson
On Tue, Oct 18, 2016 at 10:21 PM, Adrian Klaver wrote: > On 10/18/2016 06:30 PM, Patrick B wrote: > >> >> >> 2016-10-19 13:39 GMT+13:00 Michael Paquier > >: >> >> On Wed, Oct 19, 2016 at 9:24 AM, Patrick

Re: [GENERAL] pg_sample

2016-10-18 Thread Adrian Klaver
On 10/18/2016 06:30 PM, Patrick B wrote: 2016-10-19 13:39 GMT+13:00 Michael Paquier >: On Wed, Oct 19, 2016 at 9:24 AM, Patrick B > wrote: > However, this new

Re: [GENERAL] pg_sample

2016-10-18 Thread Patrick B
2016-10-19 13:39 GMT+13:00 Michael Paquier : > On Wed, Oct 19, 2016 at 9:24 AM, Patrick B > wrote: > > However, this new database test server doesn't need to have all the > data. I > > would like to have only the first 100 rows(example) of

Re: [GENERAL] pg_sample

2016-10-18 Thread Michael Paquier
On Wed, Oct 19, 2016 at 9:24 AM, Patrick B wrote: > However, this new database test server doesn't need to have all the data. I > would like to have only the first 100 rows(example) of each table in my > database. > > I'm using pg_sample to do that, but unfortunately it

[GENERAL] pg_sample

2016-10-18 Thread Patrick B
Hi guys, I got a very big database, that I need to export (dump) into a new test server. However, this new database test server doesn't need to have all the data. I would like to have only the first 100 rows(example) of each table in my database. I'm using pg_sample to do that, but