Hello,
I have a table which has billions of rows and I want to select it by
bitwise operation like,
=# CREATE TABLE IF NOT EXISTS t_bitwise (
id INTEGER NOT NULL
,status_bigint BITINT NOT NULL
,status_bit BIT(32) NOT NULL
);
=# INSERT INTO t_bitwise (id, status_bigint, status_bit) SELECT
On Tue, Jul 10, 2018 at 01:54:12PM -0400, Patrick Hemmer wrote:
> I'm looking for a way of gathering performance stats in a more usable
> way than turning on `log_statement_stats` (or other related modules).
> The problem I have with the log_*_stats family of modules is that they
> log every single
I'm looking for a way of gathering performance stats in a more usable
way than turning on `log_statement_stats` (or other related modules).
The problem I have with the log_*_stats family of modules is that they
log every single query, which makes them unusable in production. Aside
from consuming sp
Hi all,
I'm having a good bit of trouble making production-ready a query I wouldn't
have thought would be too challenging.
Below is the relevant portions of my table, which is partitioned on values
of part_key from 1-5. The number of rows is on the order of 10^7, and the
number of unique "parent
