On 7/15/20 9:38 AM, Tom Lane wrote:
Adam Sanchez writes:
I need to run 2 million queries against a three columns table t
(s,p,o) which size is 10 billions rows. The data type of each column
is string. The server has 512G RAM, 32 cores and 14T SSD (RAID 0)
Only two types of queries:
se
Adam Sanchez writes:
> I need to run 2 million queries against a three columns table t
> (s,p,o) which size is 10 billions rows. The data type of each column
> is string. The server has 512G RAM, 32 cores and 14T SSD (RAID 0)
> Only two types of queries:
> select s p o from t where s = param
>
On 7/15/20 10:10 AM, Adam Sanchez wrote:
Hi
I need to run 2 million queries against a three columns table t
(s,p,o) which size is 10 billions rows. The data type of each column
is string. The server has 512G RAM, 32 cores and 14T SSD (RAID 0)
Only two types of queries:
select s p o from t whe
Hi
I need to run 2 million queries against a three columns table t
(s,p,o) which size is 10 billions rows. The data type of each column
is string. The server has 512G RAM, 32 cores and 14T SSD (RAID 0)
Only two types of queries:
select s p o from t where s = param
select s p o from t where o =
