Re: Sample data generator for performance testing

Поиск
Список
Период
Сортировка
От arun chirappurath
Тема Re: Sample data generator for performance testing
Дата
Msg-id CAA23SdsPFiVDfBZWO-oKgq5SzZEAs9fNydgdbw=2BELMmXfxAA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Sample data generator for performance testing  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Sample data generator for performance testing
Список pgsql-general


On Wed, 3 Jan, 2024, 23:03 Adrian Klaver, <adrian.klaver@aklaver.com> wrote:
On 1/3/24 09:24, arun chirappurath wrote:
> Hi Adrian,
>
> Thanks for your mail.
>
> Is this for all tables in the database or a subset? Yes

Yes all tables or yes just some tables?
All tables.except some which has user details. 

>
> Does it need to deal with foreign key relationships? No
>
> What are the sizes of the existing data and what size sample data do you
> want to produce?1Gb and 1Gb test data. 

If the source data is 1GB and the test data is 1GB then there is no
sampling, you are using the data population in its entirety.

Yes.would like to double the load and test.

Also do we have any standard methods for sampling and generating test data


>
> On Wed, 3 Jan, 2024, 22:40 Adrian Klaver, <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     On 1/2/24 23:23, arun chirappurath wrote:
>      > Hi All,
>      >
>      > Do we have any open source tools which can be used to create
>     sample data
>      > at scale from our postgres databases?
>      > Which considers data distribution and randomness
>
>
>
>      >
>      > Regards,
>      > Arun
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>

--
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Sample data generator for performance testing
Следующее
От: Jeremy Schneider
Дата:
Сообщение: Re: Sample data generator for performance testing