Re: Pipeline Mode vs Single Row Mode / Chunked Rows Mode

2025-01-07 Thread Daniel Frey
> On 6. Jan 2025, at 20:47, Daniel Verite wrote: > > Daniel Frey wrote: > >> I tried to understand the interaction between Pipeline Mode and >> Single Row Mode / Chunked Rows Mode. It seems that it works >> sometimes, but I don't get the feeling that it was deliberately >> designed to work consi

Re: Postgres do not support tinyint?

2025-01-07 Thread Igor Korot
Hi, Ron, On Tue, Jan 7, 2025 at 11:24 PM Ron Johnson wrote: > > On Wed, Jan 8, 2025 at 12:06 AM Igor Korot wrote: >> >> Hi, ALL, >> According to https://www.postgresql.org/docs/9.1/datatype-numeric.html, the >> smallest numeric type supports numbers from -32768 to 32767/ >> >> My data will be in

Re: Postgres do not support tinyint?

2025-01-07 Thread Christophe Pettus
> On Jan 7, 2025, at 22:26, Igor Korot wrote: > I don't see the "bit" field here: > https://www.postgresql.org/docs/current/datatype-numeric.html... https://www.postgresql.org/docs/current/datatype-bit.html

Postgres do not support tinyint?

2025-01-07 Thread Igor Korot
Hi, ALL, According to https://www.postgresql.org/docs/9.1/datatype-numeric.html, the smallest numeric type supports numbers from -32768 to 32767/ My data will be in a range of [0..4], and so I guess my DB table will waste space, right? Thank you.

Re: Postgres do not support tinyint?

2025-01-07 Thread Adrian Klaver
On 1/7/25 21:06, Igor Korot wrote: Hi, ALL, According to https://www.postgresql.org/docs/9.1/datatype-numeric.html, the smallest numeric type supports numbers from -32768 to 32767/ In this case it does not matter, but you should not consult documentation that is for a version(9.1) that is ~8 y

Re: Postgres do not support tinyint?

2025-01-07 Thread Ron Johnson
On Wed, Jan 8, 2025 at 12:06 AM Igor Korot wrote: > Hi, ALL, > According to https://www.postgresql.org/docs/9.1/datatype-numeric.html, > the > smallest numeric type supports numbers from -32768 to 32767/ > > My data will be in a range of [0..4], and so I guess my DB table will waste > space, righ

Re: Postgres do not support tinyint?

2025-01-07 Thread David G. Johnston
On Tuesday, January 7, 2025, Ron Johnson wrote: > > 3. The "bit" type might serve your needs. > > You suggest a type with a minimum size of 6 bytes when the complaint is that the otherwise acceptable 2 byte data type is too large? David J.

Re: Postgres do not support tinyint?

2025-01-07 Thread Christophe Pettus
> On Jan 7, 2025, at 22:44, David G. Johnston > wrote: > > You suggest a type with a minimum size of 6 bytes when the complaint is that > the otherwise acceptable 2 byte data type is too large? Although it's not clear from the OP's question, if there are going to be a significant number of

Re: Postgres do not support tinyint?

2025-01-07 Thread Tom Lane
"David G. Johnston" writes: > On Tuesday, January 7, 2025, Ron Johnson wrote: >> 3. The "bit" type might serve your needs. > You suggest a type with a minimum size of 6 bytes when the complaint is > that the otherwise acceptable 2 byte data type is too large? I think the point here is that ther