On Mon, 2023-11-13 at 17:06 -0800, Benjamin Leis wrote:
> I'm looking at a pg_stat_activity dump where there are a group of active
> threads stuck for a long time in MessageQueueSend
> 7:52.394089+00 | IPC | MessageQueueSend | active |
> | 27406510 | -5892847938856697008 | SELECT ..
I'm looking at a pg_stat_activity dump where there are a group of active
threads stuck for a long time in MessageQueueSend
7:52.394089+00 | IPC | MessageQueueSend | active |
| 27406510 | -5892847938856697008 | SELECT
Does this mean they are blocked on clients reading data or does it
represen
> On 13 Nov 2023, at 18:00, Tom Lane wrote:
(…)
> * If you use MacPorts or Homebrew, maybe that's out of date?
> Try removing the associated directories from your PATH to see
> if it works better.
Perhaps even worse; you had old binaries from an Intel architecture that were
migrated onto a n
On Fri, Nov 3, 2023 at 3:34 PM David Gauthier wrote:
> I'm asking about the possibility of indexing portions of a column's value
> where the column has a static field format. Example, a char(8) which
> contains all hex values (basically a hex number that's always 8 chars wide,
> leading zeros if
On 11/13/23 10:14, Anthony Apollis wrote:
I cant get distinct data, im tying to break up the insert into chunks
and it does not help
Statements without context will not yield answers. First and foremost
you will need to define what you mean by distinct data? From the queries
you show that is
I cant get distinct data, im tying to break up the insert into chunks and
it does not help
On Mon, 13 Nov 2023 at 20:05, Adrian Klaver
wrote:
> On 11/13/23 09:54, Anthony Apollis wrote:
>
> Please reply to list also
> Ccing list
>
> > Hi Adrian
> >
> > Yes, the Account number column(s) are not u
On 11/13/23 09:54, Anthony Apollis wrote:
Please reply to list also
Ccing list
Hi Adrian
Yes, the Account number column(s) are not unique. I brought in the
primary keys in both tables. If I enforce referential integrity on the
dimension table, will this solve the issue?
1) Your original po
Shaik Mohammad Mujeeb writes:
> Sorry for not providing the context properly in the previous mail. I have
> recently updated to macOS 14.1.1 and tried to compile postgres. I have
> mentioned the steps I had followed and the output of those steps in the
> attached file. I am getting the same error
"David G. Johnston" writes:
> On Mon, Nov 13, 2023 at 9:17 AM Kirk Wolak wrote:
>> These are the most trivial examples. The second one results in a syntax
>> error. Which implies that:
>> 1) There can only be one recursive CTE at the same level?
>> 2) It must be the FIRST CTE?
> There is only
On 11/13/23 08:45, Adrian Klaver wrote:
On 11/12/23 23:02, Anthony Apollis wrote:
Please advice. I brought in data from SAP and assigned unique primary
key to the table:
I joined it with a dimension table.
Joining code
fact."IMETA_ZTRB_MP$F_ZTBR_TA_BW"ASfact
LEFTJOINdim."IMETA_BRACS_Mapp
On 11/12/23 23:02, Anthony Apollis wrote:
Please advice. I brought in data from SAP and assigned unique primary
key to the table:
I joined it with a dimension table.
Joining code
fact."IMETA_ZTRB_MP$F_ZTBR_TA_BW"ASfact
LEFTJOINdim."IMETA_BRACS_Mapping"ASbracs_map
ONfact."Account_Number"=b
On Mon, Nov 13, 2023 at 9:17 AM Kirk Wolak wrote:
> These are the most trivial examples. The second one results in a syntax
> error. Which implies that:
> 1) There can only be one recursive CTE at the same level?
> 2) It must be the FIRST CTE?
>
There is only one WITH keyword as well, that doe
Team,
This was strange. I wanted to set up a CTE that would FEED my recursive
query.
And also feed the results filtering...
These are the most trivial examples. The second one results in a syntax
error. Which implies that:
1) There can only be one recursive CTE at the same level?
2) It must b
Shaik Mohammad Mujeeb writes:
> After updating to macOS 14.1.1, I am facing below error while compiling
> postgres. Can someone help me in solving this?
> ld: multiple errors: archive member '/' not a mach-o file in
> '/src/port/libpgport.a'; archive member '/' not a mach-o file in
> '/src/common
>
> On Nov 13, 2023 at 3:45 AM, Shaik Mohammad Mujeeb
> wrote:
>
>
> Hi Team,
>
> After updating to macOS 14.1.1, I am facing below error while compiling
> postgres. Can someone help me in solving this?
>
>
>
> ld: multiple errors: archive member '/' not a mach-o file in
>
On Mon, Mar 13, 2023 at 06:43:01PM +0100, Peter J. Holzer wrote:
> On 2023-03-13 09:21:18 -0800, Israel Brewster wrote:
> > I’m running a postgresql 13 database on an Ubuntu 20.04 VM that is a bit
> > more
> > memory constrained than I would like, such that every week or so the various
> > process
Hi Team,
After updating to macOS 14.1.1, I am facing below error while compiling
postgres. Can someone help me in solving this?
ld: multiple errors: archive member '/' not a mach-o file in
'/src/port/libpgport.a'; archive member '/' not a mach-o file in
'/src/common/libpgcommon.a'
clang: error: l
17 matches
Mail list logo
