What is your baseline expectation?
With what size of db table, what query should take how much time
How much server resources can be used?
If this seems to be a timeseries db,
Are the rows append only and random insertion order ?
You are create partitions based on time and sub partitions on som
Hi,
I'm looking for tips on optimizing a search query where someone searches
for content within a post and wants to sort the results by a timestamp. I
have a table `posts` with a `created` field (timestamp) and a post_tsv
column (TSVECTOR). Likewise I have a GIN Index on the `post_tsv` field and
a
